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 |
How this entity was disambiguated
This entity first appeared as the object of triple T4278664 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: SQL*Plus Context triple: [Automatic Storage Management, configuredUsing, SQL*Plus]
-
A.
PL/SQL
PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
-
B.
Oracle Database
Oracle Database is a widely used enterprise relational database management system known for its scalability, reliability, and robust support for complex data workloads.
-
C.
Rapid SQL
Rapid SQL is a database development and SQL IDE tool from Embarcadero Technologies designed to help developers and DBAs build, test, and optimize SQL code across multiple database platforms.
-
D.
Aqua Data Studio
Aqua Data Studio is a database management and development environment that provides tools for querying, visualizing, and administering a wide range of relational and NoSQL databases.
-
E.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: SQL*Plus Target entity description: 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.
-
A.
PL/SQL
PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
-
B.
Oracle Database
Oracle Database is a widely used enterprise relational database management system known for its scalability, reliability, and robust support for complex data workloads.
-
C.
Rapid SQL
Rapid SQL is a database development and SQL IDE tool from Embarcadero Technologies designed to help developers and DBAs build, test, and optimize SQL code across multiple database platforms.
-
D.
Aqua Data Studio
Aqua Data Studio is a database management and development environment that provides tools for querying, visualizing, and administering a wide range of relational and NoSQL databases.
-
E.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
- F. None of above. chosen
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 ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: SQL*Plus Description of subject: 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.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.