Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

A retrieval with no third argument

SQL>  SELECT SUBSTR('My address is 123 Fourth St.',6)  FROM dual; SUBSTR('MYADDRESSIS123F ----------------------- dress is 123 Fourth St. SQL>