Simple demo for SUBSTR function
SQL> SQL> SQL> SELECT SUBSTR('My address is 123 Fourth St.',1,12) FROM dual; SUBSTR('MYAD ------------ My address i SQL>