SQL Plus: Difference between revisions

Revision as of 21:02, 25 September 2008

Revision as of 03:48, 19 November 2008

Line 1:

'''SQL*Plus''' is an [[Oracle database|Oracle]] command line utility which runs [[SQL]] and [[PL/SQL]] commands interactively or from a script. Complete documentation for SQL*Plus can be found on the Oracle website.<ref>{{cite web | title=Oracle SQL*Plus documentation | url=http://www.oracle.com/technology/docs/tech/sql_plus/index.html | accessdate=2007-11-26}}</ref>.

SQL*Plus is a simple tool with a basic command line interface. It is commonly used because it is available in almost any Oracle software installation.

==Command types==

SQL*Plus understands SQL statements, PL/SQL blocks, and internal commands.<ref name="CommandRef">{{cite web | url=http://www.orafaq.com/faq/sqlplus | title=SQL*Plus at orafaq.com | accessdate=2007-11-26}}</ref>. All of these maycan be combined in scripts.

Launch SQL*Plus can be launched, for example, by entering <code>sqlplus scott/tiger</code>, where <code>scott</code> is an Oracle user with the password <code>tiger</code>. SQL*Plus then presents a prompt:

<pre>SQL&gt;</pre>

Enter a SQL statement (terminated by a semicolon), PL/SQL block, or other command.

<pre>SQL&gt; select 'Hello world' as example from dual;

Line 24:

The current name of the product is ''SQL*Plus''.

==UsesUsage==

Interactive use has mostly been replaced by graphical interfaces from Oracle or third parties. Oracle shops typically use SQL*Plus scripts for batch updating, or simple reports. {{fact}}

==Compatibility==

Other vendors have made their software somewhat compatible with SQL*Plus script commands or offer a SQL*Plus mode of operation. Products include TOAD from Quest and others.{{fact}}

==References==

{{Reflist}}