SQL*Plus

Deprecated SQL*Plus Commands in Oracle 11g R2

This just a short note to point out that the below SQL*Plus commands are deprecated as of Oracle 11g R2, but available in the current release of SQL*Plus for backward compatibility. The documentation states that this may only be available by setting the SQLPLUSCOMPATIBILITY variable in the future releases.  You should modify scripts using obsolete …

Deprecated SQL*Plus Commands in Oracle 11g R2Read More »

SQL*Plus Feature: TIMING and SET TIMING command

SET TIMING—one of the most frequently used commands—displays timing statistics on each SQL command or PL/SQL block. What if you want to collect timing statistics for multiple group of statements? TIMING command becomes handy in such situation—one of things that I knew and have forgotten over time. It can be used to collect data to do …

SQL*Plus Feature: TIMING and SET TIMING commandRead More »