From the editor, a slash (/) is added to execute the statement and no semicolon is used. SQL> SELECT SUBSTR('My address is 123 Fourth St.',1,12)FROM dual 2 /SUBSTR('MYAD------------My address iSQL>