Using SQL*Plus and Oracle Enterprise Manager


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.


Oracle Database Database Control Grid Control Management Repository Clear Command 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati 2009

Personalised recommendations