SQL Plus: Difference between revisions

Revision as of 20:08, 19 November 2008

Revision as of 23:54, 20 November 2008

Line 1:

In [[computing]], '''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 foundappears 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. ItProgrammers isand DBAs commonly used because it isas the default available fundamental interface in almost any Oracle software installation.

==Command types ==

SQL*Plus understands SQLthree statements,categories PL/SQLof blocks, and internal commands.text:<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 can be combined in scripts.

# SQL statements

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:

# PL/SQL blocks

<pre>SQL&gt;</pre>

# SQL*Plus internal commands, for example:

## environment control commands such as SET

## environment monitoring command such as SHOW

Scripts can include all of these components.

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

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

An Oracle programmer in the appropriately-configured software environment can launch SQL*Plus, for example, by entering:

<code>sqlplus scott/tiger</code>

where the Oracle user <code>scott</code> has the password <code>tiger</code>. SQL*Plus then presents a prompt with the default form of:

<pre>SQL&gt;</pre>

Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example:

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

EXAMPLE

Line 18 ⟶ 33:

== History ==

Oracle Corporation dubbed SQL*Plus's predecessor was called ''UFI'' (''for "User Friendly Interface''"). UFI was included in Oracle database releases up to Version 4.

After new features were added to UFI, it was renamed internally to ''Advanced UFI''. The name "Advanced UFI" was changed to SQL*Plus before this version was released.

Line 26 ⟶ 41:

==Usage==

Interactive use has mostly been replaced by graphical interfaces from Oracle or third parties. Oracle shops typically continue to use SQL*Plus scripts for batch updating or simple reports.{{Fact|date=November 2008}}

Oracle Corporation's wrappers/guifications/replacements for SQL*Plus include:

* Oracle SQL*Plus Worksheet, a component of [[Oracle Enterprise Manager | OEM]]<ref>{{cite web

==Compatibility==

| url = http://docs.cs.cf.ac.uk/html/601/node4.html

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|date=November 2008}}

| title = The SQL*Plus Worksheet

| accessdate = 2008-11-21

| author =

| last = Evans

| first = Robert

| authorlink =

| coauthors =

| date = 2008-10-01

| year =

| month =

| work =

| publisher = Cardiff University

| ___location =

| pages =

| doi =

| archiveurl =

| archivedate =

| quote = Oracle's SQL*Plus Worksheet is a straight-forward, easy-to-use, graphical user interface for SQL.

}}

</ref>

* iSQL*Plus or iSQLPlus, a web-based utility<ref>{{cite web

| url = http://www.orafaq.com/wiki/ISQLPlus

| title = ISQLPlus

| accessdate = 2008-11-21

| author =

| last =

| first =

| authorlink =

| coauthors =

| date = 2008-02-29

| year =

| month =

| work =

| publisher = Oracle FAQ

| ___location =

| pages =

| language =

| doi =

| archiveurl =

| archivedate =

| quote = iSQLPlus (iSQL*Plus) is a web-based utility similar to the SQL*Plus command line utility for executing SQL and PL/SQL commands.

}}

</ref>

* SQL Worksheet,<ref>{{cite web

| url = http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm#nf_sql

| title = Oracle SQL Developer 1.5: Feature List

| accessdate = 2008-11-21

| author =

| last =

| first =

| authorlink =

| coauthors =

| date =

| year =

| month =

| work =

| publisher = Oracle Corporation

| ___location =

| pages =

| language =

| doi =

| archiveurl =

| archivedate =

| quote = The SQL*Plus commands supported by Oracle SQL Developer SQL Worksheet are listed [...]

}}

</ref> a component of [[Oracle SQL Developer]]

* SQL Workshop (part of [[Oracle Application Express]])<ref>{{cite web

| url = http://www.oracle.com/technology/products/database/application_express/html/what_is_apex.html

| title = Oracle Application Express

| accessdate = 2008-11-21

| author =

| last =

| first =

| authorlink =

| coauthors =

| date =

| year =

| month =

| format =

| work =

| publisher = Oracle Corporation

| ___location =

| pages =

| language =

| doi =

| archiveurl =

| archivedate =

| quote = SQL Workshop provides tools to enable you to view and manage database objects from a Web browser. Use SQL Commands to run SQL and PL/SQL statements. ...

}}

</ref>

==References 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 (software) | TOAD]] from [[Quest Software]].{{Fact|date=November 2008}}

==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]