From Wikipedia, the free encyclopedia - View original article
SQL*Plus The most basic Oracle utility, with a basic command-line interface, commonly used by users, administrators, and programmers.
SQL*Plus understands three categories of text:
Scripts can include all of these components.
An Oracle programmer in the appropriately configured software environment can launch SQL*Plus, for example, by entering:
where the Oracle user
scott has the password
tiger. SQL*Plus then presents a prompt with the default form of:
Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example:
SQL> select 'Hello world' as example from dual; EXAMPLE -------------------------------- Hello world
The first version of SQL*Plus was called UFI ("User Friendly Interface"). UFI appeared in Oracle database releases up to Version 4.
After Oracle programmers had added new features to UFI, its name became Advanced UFI. The name "Advanced UFI" changed to "SQL*Plus" before the release of this[which?] version.
As of January 2012[update] the product continues to bear the name SQL*Plus.
Graphical interfaces from Oracle or third parties have diminished the proportion of Oracle database end-users who depend on the SQL*Plus environment. Oracle shops typically continue to use SQL*Plus scripts for batch updating or simple reports.
Oracle Corporation's wrappers/gui-fications/replacements for SQL*Plus include:
Starting from Oracle database 11g, iSqlplus (web based) and sqlplus graphical GUI no longer ship with Oracle database software. The command-line SQL*Plus interface continues in use, mostly for non-interactive scripting or for administrative purposes (
connect internal before Oracle 8i;
sqlplus ... as sysdba later).
|This section requires expansion. (July 2009)|
SQL*Plus-internal variables, accessible within an SQL*Plus session, include:
variable[...] The value of the bind variable can then be printed with