SPT ZA Zahir Mohideen dbms_output in SQL Developer In sqlplus , you can shorten some of the SET options and it works the same as if the full command is issued.