This appendix covers earlier versions of some SQL*Plus commands. These older commands still function within SQL*Plus, but SQL*Plus provides newer commands that have improved functionality. The old ...

Read this chapter while sitting at your computer and try out the examples shown. Before beginning, make sure you have access to the sample tables described. To begin using SQL*Plus, you must first ...

Oracle9i offers some great tools to make it easy to view the execution plan and trace information for a SQL statement. Prior to Oracle8i, you had to create a plan table and execute special syntax to ...

We often see DBAs use somewhat cumbersome methods to document or write implementation steps that involve a combination of both OS (i.e. "Bash") and Oracle (i.e. "SQL Plus") commands. However, with ...