Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Retrieval begins at position 5 and again goes for 12 characters

SQL>  SELECT SUBSTR('My address is 1234 Fourth St.',5,12) FROM dual; SUBSTR('MYAD ------------ ddress is 12 SQL>