SQL*Plus

SQL*Plus - Оракл теру утилитасы

|archivedate = 2007-11-09}}</ref> 

1. SQL statements
2. PL/SQL blocks
3. SQL*Plus internal commands, for example:
   1. environment control commands such as SET
   2. environment monitoring commands 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

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 the product continues to bear the name SQL*Plus.

Usage

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:

• Oracle SQL*Plus Worksheet, a component of OEM
• iSQL*Plus or iSQLPlus, a web-based utility
• SQL Worksheet, a component of Oracle SQL Developer
• SQL Workshop (part of Oracle Application Express)

Oracle 11g

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).

Compatibility

Other vendors have made their software somewhat compatible with SQL*Plus script commands or offer a SQL*Plus mode of operation. Relevant products include TOAD from Quest Software.^{[дереккөзі?]}

Integration

Variables

SQL*Plus-internal variables, accessible within an SQL*Plus session, include:

• user variables, displayable with the DEFINE command and referenceable with one or two cases of a prefixed character (default prefixes: '&' and '&&'). These variables are called "substitution variables" and can be used anywhere in a SQL or PL SQL statement or in SQL Plus commands. They can be populated by a literal using DEFINE or from the database using the column command.
  • predefined variables, prefixed with an underscore ('_')
  • substitution variables, useful for interacting with user-input
• bind variables, prefixed by a colon (':'), which can interact with the PL/SQL environment. Displayable with the VARIABLE and PRINT commands

Supplementary software

• SQL Assistant SQL Assistant add-on for SQL*Plus Windows version extends SQL*Plus with SQL automatic word completion, in-line Oracle SQL Reference, data export/import, code unit testing, data browsing, and code development functions.
• rlwrap rlwrap does GNU Readline like command completion for SQL*Plus on UNIX and Linux.

-->

Тағы қараңыз

• Oracle SQL Developer

External links

• SQL*Plus documentation
• SQL*Plus FAQ
• SQL*Plus tutorial