The SUBSTR functions return a portion of string, beginning at a specified position in the string. The functions vary in how they calculate the length of the substring to return.
Note: When position is negative, then the function counts backward from the end of string.
SUBSTR(STRING, START_POSITION, NUMBER_OF_CHARACTER)
Example:
SQL> SELECT SUBSTR('ARPITSINHA',6,5) FROM DUAL;
SUBSTR
----------
SINHA
No comments:
Post a Comment