SQL: What is SQL *Plus?

Archived Historical Data: Not Actively Maintained.


SQL *Plus,  is installed with every Oracle Database Server or Client installation on any given desktop. 

SQL *Plus provides access to the Oracle Database, and has its own commands and environment.  Through it, you are able to enter and execute  PL/SQL, SQL, and SQL *Plus and operating system commands to:

  • Perform calculations on, store, print, and format from query results.
  • View object and table definitions
  • Run and develop batch scripts
  • Perform database administration

SQL *Plus can be used to make reports interactively, generate reports as batch processes, and to output the results to screen, text file, or to HTML file for browsing on the Internet.  You can make reports dynamically by using the dynamic reporting capability of iSQL *Plus , or using the HTML output facility of SQL *Plus to generate reports dynamically.

3/13/2013 10:16:41 AM