SQL Plus
≈ 2 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.
SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers. ==Command types== SQL Plus understands five categories of text: SQL statements PL/SQL blocks SQL Plus internal commands, for example: environment control commands such as SET environment monitoring commands such as SHOW Comments External commands prefixed by the ! char 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 ==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) ==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. ==References== ==External links== SQL Plus documentation Plus FAQ SQL Plus FAQ SQL Plus tutorial
Text derived from https://en.wikipedia.org/w/index.php?oldid=1317110476 under CC BY-SA 4.0; modifications have been made.