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

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

See the START command for more information. You have the option of entering logon. If you do not specify logon and do specify start, SQL*Plus assumes that the first line of the command file contains a ...

Ensure SQL Plus is installed on your system and properly configured to connect to your Oracle database. Configure your Oracle database connection. For more details on configuring SQL Plus, see ...

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