Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

If begin is negative, then retrieval occurs from the right-hand side of original string

SQL>  SELECT SUBSTR('My address is 123 Fourth St.',-9,5) FROM dual; SUBST ----- ourth SQL>