Oracle PLSQL | oracle substr right
ThisOracletutorialexplainshowtousetheOracle/PLSQLSUBSTRfunctionwithsyntaxandexamples.DescriptionTheOracle/PLSQLSUBSTRfunctionsallowsyoutoextractasubstringfromastring.SyntaxThesyntaxfortheSUBSTRfunctioninOracle/PLSQLis:SUBSTR(string,start_position[,length])ParametersorArgumentsstringThesourcestring.start_positionThestartingpositionforextraction.Thefirstpositioninthestringisalways1.lengthOptional.Itisthenumberofcharacterstoextract.Ifthisparameterisomitted,theSUBSTRfunctionwillreturntheentirest...
This Oracle tutorial explains how to use the Oracle/PLSQL SUBSTR function with syntax and examples.
DescriptionThe Oracle/PLSQL SUBSTR functions allows you to extract a substring from a string.
SyntaxThe syntax for the SUBSTR function in Oracle/PLSQL is:
SUBSTR( string, start_position [, length ] ) Parameters or Arguments string The source string. start_position The starting position for extraction. The first position in the string is always 1. length Optional. It is the number of characters to extract. If this parameter is omitted, the SUBSTR function will return the entire string. ReturnsThe SUBSTR function returns a string value.If length is a negative number, then the SUBSTR function will return a NULL value.
Note If start_position is 0, then the SUBSTR function treats start_position as 1 (ie: the first position in the string). If start_position is a positive number, then the SUBSTR func...