Overview of SQL Command Line

Previous

Next

SQL Command Line (SQL*Plus) is a command-line tool for accessing Oracle Database XE. It enables you to enter and run SQL, PL/SQL, and SQL*Plus commands and statements to:

• Query, insert, and update data

• Execute PL/SQL procedures

• Examine table and object definitions

• Develop and run batch scripts

• Perform database administration

You can use SQL Command Line to generate reports interactively, to generate reports as batch processes, and to write the results to a text file, to a screen, or to an HTML file for browsing on the Internet.