SQL*Plus
E427645
SQL*Plus is Oracle's command-line tool for interacting with Oracle databases, allowing users to execute SQL and PL/SQL commands and perform administrative tasks.
All labels observed (1)
| Label | Occurrences |
|---|---|
| SQL*Plus canonical | 1 |
Statements (65)
| Predicate | Object |
|---|---|
| instanceOf |
Oracle database tool
ⓘ
command-line interface ⓘ database client ⓘ |
| canBeInvokedBy | sqlplus executable ⓘ |
| canExecute |
Data Definition Language statements
ⓘ
Data Manipulation Language statements ⓘ PL/SQL procedures and functions ⓘ transaction control statements ⓘ |
| developer | Oracle Corporation NERFINISHED ⓘ |
| documentationURL | https://docs.oracle.com/en/database/oracle/oracle-database/ ⓘ |
| hasCommand |
@ (run script)
ⓘ
@@ (run script from same path) ⓘ COLUMN ⓘ CONNECT ⓘ DESCRIBE ⓘ DISCONNECT ⓘ EXIT ⓘ PROMPT ⓘ SET ⓘ SPOOL ⓘ START ⓘ WHENEVER OSERROR ⓘ WHENEVER SQLERROR ⓘ |
| hasMode |
batch mode
ⓘ
interactive mode ⓘ |
| includedIn |
Oracle Database client installation
ⓘ
Oracle Database server installation ⓘ Oracle Instant Client NERFINISHED ⓘ |
| primaryUse |
database administration tasks
ⓘ
executing PL/SQL blocks ⓘ executing SQL statements ⓘ interacting with Oracle databases ⓘ |
| relatedTo |
Oracle SQL Developer
NERFINISHED
ⓘ
SQLcl NERFINISHED ⓘ |
| requires | Oracle client libraries ⓘ |
| runsOn |
Linux
NERFINISHED
ⓘ
UNIX NERFINISHED ⓘ Windows NERFINISHED ⓘ macOS NERFINISHED ⓘ |
| supports |
PL/SQL
NERFINISHED
ⓘ
SQL NERFINISHED ⓘ |
| supportsAuthentication |
OS authentication (external) in some configurations
ⓘ
username and password ⓘ |
| supportsFeature |
ACCEPT command for user input
ⓘ
SQL*Plus command history (in some environments via shell) ⓘ SQL*Plus scripting ⓘ bind variables ⓘ column formatting with COLUMN command ⓘ connecting to remote Oracle databases ⓘ describing database objects with DESCRIBE ⓘ environment settings via SET commands ⓘ error handling with WHENEVER SQLERROR ⓘ formatting query output ⓘ login scripts (glogin.sql and login.sql) ⓘ output pagination ⓘ running scripts from files ⓘ server output display via SET SERVEROUTPUT ⓘ spooling query output to files ⓘ substitution variables ⓘ timing of commands with SET TIMING ⓘ variable definition with DEFINE and UNDEFINE ⓘ |
| typicalFileExtensionForScripts |
.pls
ⓘ
.sql ⓘ |
| usesProtocol |
Oracle Net
NERFINISHED
ⓘ
TCP/IP NERFINISHED ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.