SUBSTR: from the right-hand side of original string : SUBSTR « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. SUBSTR

SUBSTR: from the right-hand side of original string

 
SQL>
SQL> -- SUBSTR: from the right-hand side of original string:
SQL>
SQL> SELECT SUBSTR('My address is 123 Fourth St.',-9,5) FROM dual;

SUBST
-----
ourth

SQL>








Related examples in the same category

1.SUBSTR() returns a portion of string, beginning at numeric_position up to a specified substring_length characters long.
2.Substr: retrieve a portion of the string
3.SUBSTR: get the sub-string
4.Simple demo for SUBSTR function
5.SUBSTR and INSTR are used together
6.select substr( '1234567890', 5 )
7.Use SUBSTR to decode a column
8.use substr in IF statement
9.substr(date value,8)+16