Content deleted Content added
Added mention of scripting |
No edit summary |
||
Line 1:
'''SQL*Plus''' is an [[Oracle database|Oracle]] command line utility which allows users to run [[SQL]] and [[PL/SQL]] commands interactively or from a script. Complete documentation for the SQL*Plus interpreter 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, however it is commonly used as it is almost always available in 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 may be combined in a script.
An example session might begin by executing <code>sqlplus scott/tiger</code> where <code>scott</code> is an Oracle user with the password <code>tiger</code>. SQL*Plus will present a prompt:
<pre>SQL></pre>
You might then execute an SQL query:
<pre>SQL> select 'Hello world' as example from dual;
EXAMPLE
--------------------------------
Hello world</pre>
==Versions==
Line 32 ⟶ 45:
==References==
{{Reflist}}
==External links==
* [http://www.oracle.com/technology/docs/tech/sql_plus/index.html SQL*Plus]
* [http://www.orafaq.com/faq/sqlplus SQL*Plus FAQ]
| |||