Using timing in SQL*Plus

Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is optional SQL> timing start monitor_timing SQL> select sysdate from dual; SYSDATE ——— 11-APR-10 — display time elapsed for current timer SQL> timing show timing for: monitor_timing Elapsed: 00:00:21.35 SQL> select count(1) FROM dba_objects; COUNT(1) ———- 9728 — show elapsed time SQL> timing show timing for: … Continue reading Using timing in SQL*Plus

How to skip blank lines in between SQL statements in SQL*Plus?

If a SQL script file has blank lines in between SQL statements one may see errors when executing the script in SQL*Plus so if one would like to ignore the blanklines in SQL*Plus one can ignore them by set blanklines on. Example: SQL> select object_name 2 SQL> from dba_objects; SP2-0734: unknown command beginning “from dba_o…” – rest of line ignored. SQL> set sqlblanklines on SQL> … Continue reading How to skip blank lines in between SQL statements in SQL*Plus?