SQL*Plus executes this command file whenever any user starts SQL*Plus and SQL*Plus establishes the Oracle connection. The Site Profile allows the DBA to set up SQL*Plus environment defaults for all ...

The SQL*Plus column command is useful for setting a column’s format to appear more aesthetically pleasing in an SQL*Plus query and other work done in SQL*Plus.

For detailed statistics, you had to run the TKPROF utility. We can now get the execution plan and trace information for any SQL statement very quickly and easily with a few SQL*Plus commands.

If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple <code>"create table foo as select ...