In computing, SQL*Plus, an Oracle command-line utility, runs SQL and PL/SQL commands interactively or from a script. Complete documentation for SQL*Plus appears on the Oracle website.[1]
SQL*Plus is a simple tool with a basic command-line interface. Programmers and DBAs commonly used it as the default available fundamental interface in almost any Oracle software installation.
Command types
SQL*Plus understands three categories of text:[2]
- SQL statements
- PL/SQL blocks
- 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.
An Oracle programmer in the appropriately-configured software environment can launch SQL*Plus, for example, by entering:
sqlplus scott/tiger
where the Oracle user scott has the password tiger. SQL*Plus then presents a prompt with the default form of:
SQL>
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
History
Oracle Corporation dubbed SQL*Plus's predecessor 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.
The current name of the product is SQL*Plus.
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.[citation needed]
Oracle Corporation's wrappers/guifications/replacements for SQL*Plus include:
- Oracle SQL*Plus Worksheet, a component of OEM[3]
- iSQL*Plus or iSQLPlus, a web-based utility[4]
- SQL Worksheet,[5] a component of Oracle SQL Developer
- SQL Workshop (part of Oracle Application Express)[6]
Oracle 11g
Starting from Oracle database 11g, iSqlplus (web based) and sqlplus graphical GUI are not included[7]. The command line interface is still retained, which is mostly used non-interactively or as purpose of "connect internal" (administration usage) before Oracle 8i.
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 Software.[citation needed]
References
- ^ "Oracle SQL*Plus documentation". Retrieved 2007-11-26.
- ^ "SQL*Plus at orafaq.com". Retrieved 2007-11-26.
- ^ Evans, Robert (2008-10-01). "The SQL*Plus Worksheet". Cardiff University. Retrieved 2008-11-21.
Oracle's SQL*Plus Worksheet is a straight-forward, easy-to-use, graphical user interface for SQL.
{{cite web}}: Cite has empty unknown parameters:|month=and|coauthors=(help) - ^ "ISQLPlus". Oracle FAQ. 2008-02-29. Retrieved 2008-11-21.
iSQLPlus (iSQL*Plus) is a web-based utility similar to the SQL*Plus command line utility for executing SQL and PL/SQL commands (available up to Oracle 10gR2).
{{cite web}}: Cite has empty unknown parameters:|month=and|coauthors=(help) - ^ "Oracle SQL Developer 1.5: Feature List". Oracle Corporation. Retrieved 2008-11-21.
The SQL*Plus commands supported by Oracle SQL Developer SQL Worksheet are listed [...]
{{cite web}}: Cite has empty unknown parameters:|month=and|coauthors=(help) - ^ "Oracle Application Express". Oracle Corporation. Retrieved 2008-11-21.
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. ...
{{cite web}}: Cite has empty unknown parameters:|month=and|coauthors=(help) - ^ Deprecated Components in Oracle Database 11g Release 1 (11.1), retrieve by 25-Jun-2009
See Also
External links
 | This database software-related article is a stub. You can help Wikipedia by expanding it. |