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 ...

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.

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.

These commands must be prepended with cmd /C to be executed appropriately. However, this step is unnecessary when invoking SQL*Plus from Groovy on Windows because SQL*Plus is a separate executable.

The other user could issue the SQL*Plus command: SQL> connect ANOTHER USER SQL> @clone SCOTT FUNCTION FOO This works but it still requires SQL*Plus sessions and scripts.