<<Previous Next>>
Oracle - What
is SQL*Plus? - April 10, 2009
at 11:00 AM
What is SQL*Plus?
SQL*Plus is an interactive and batch query tool.
It gets
installed with every Oracle Database Server or Client installation.
It has a command-line user interface, a Windows Graphical User
Interface (GUI) and the iSQL*Plus web-based user interface.
SQL*Plus has its own commands and environment, and it provides
access to the Oracle Database.
Following types of commands can be entered and executed:
- SQL
- PL/SQL
- SQL*Plus
- Operating system commands
With the above commands, following actions can be performed:
- Develop and run batch scripts
- Perform database administration
- Format, perform calculations on, store, and print from query
results
- Examine table and object definitions
SQL*Plus can be used to:
- Generate reports interactively
- Generate reports as batch processes
- Output the results to text file, to screen, or to HTML file
for browsing on the Internet.
- Generate reports dynamically using the HTML output facility of
SQL*Plus, or using the dynamic reporting capability of iSQL*Plus
to run a script from a web page.
Also read
The SET command can be used to change the settings in the
SQl*PLUS environment : SET AUTOCOMMIT OFF: Turns off the auto-commit
feature, SET FEEDBACK OFF............
The behaviour of SQL PLUS depends on some environmental variables
predefined in the OS: ORACLE_HOME: This variable stores the home
directory where the Oracle client.............
The spooling feature facilitates copying of all the contents of
the command line SQL*Plus to a specified file. This feature is
called Spooling............
Input buffer feature of the command-line SQL*Plus tool allows a
revision of multiple-line command and rerunning it with a couple of
simple commands. The last SQL statement is............
|
