SQL>SQL> SQL> SELECT SUBSTR('My address is 123 Fourth St.',1,12) FROM dual;SUBSTR('MYAD------------My address iSQL>