Using SQL*Plus and Oracle Enterprise Manager

Abstract

You can connect to and work with Oracle databases in many ways. Chances are, though, that you’ll spend a lot of time using the Oracle SQL*Plus interface and a set of commands known as SQL*Plus commands. The SQL*Plus interface provides you with a window into the Oracle database, and Oracle developers use the interface extensively to create SQL and PL/SQL program units. The interface is a valuable tool for Oracle DBAs for several reasons:

• You can use it to run SQL queries and PL/SQL (Oracle’ procedural language extension to SQL) code blocks and to receive the results.

• You can issue DBA commands and automate jobs.

• It enables you to start up and shut down the database.

• It provides you with a convenient way to create database administration reports.