PL/SQL
E97097
PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
All labels observed (2)
| Label | Occurrences |
|---|---|
| PL/SQL canonical | 3 |
| Oracle PL/SQL | 2 |
How this entity was disambiguated
This entity first appeared as the object of triple T816829 — 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: PL/SQL Context triple: [Oracle Database, supportsQueryLanguage, PL/SQL]
-
A.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
-
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.
PostgreSQL
PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.
-
D.
DBE
DBE is the title "Dame Commander of the Order of the British Empire," a high-ranking honor awarded in the British honours system.
-
E.
IBM DB2
IBM DB2 is a family of enterprise-grade relational database management systems developed by IBM, widely used for high-performance, scalable data storage and transaction processing across mainframe, distributed, and cloud environments.
- 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: PL/SQL Target entity description: PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
-
A.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
-
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.
PostgreSQL
PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.
-
D.
DBE
DBE is the title "Dame Commander of the Order of the British Empire," a high-ranking honor awarded in the British honours system.
-
E.
IBM DB2
IBM DB2 is a family of enterprise-grade relational database management systems developed by IBM, widely used for high-performance, scalable data storage and transaction processing across mainframe, distributed, and cloud environments.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
Oracle technology
ⓘ
SQL extension ⓘ procedural programming language ⓘ |
| basedOn |
Ada (programming language)
ⓘ
surface form:
Ada
|
| designedFor |
Oracle Database
ⓘ
relational database management ⓘ |
| developer | Oracle Corporation ⓘ |
| documentationURL | https://docs.oracle.com/en/database/oracle/oracle-database/ ⓘ |
| extends | SQL ⓘ |
| hasComponent |
PL/SQL engine
ⓘ
package body ⓘ package specification ⓘ |
| hasFeature |
autonomous transactions
ⓘ
bulk SQL operations ⓘ dynamic SQL ⓘ exception handling ⓘ object-oriented extensions ⓘ overloading of procedures and functions ⓘ packages for code encapsulation ⓘ triggers on tables and views ⓘ |
| integratesWith | SQL ⓘ |
| introducedBy |
Oracle Database
ⓘ
surface form:
Oracle7
|
| paradigm |
imperative
ⓘ
procedural ⓘ |
| primaryUse |
ETL processes
ⓘ
batch processing ⓘ business logic implementation ⓘ data validation ⓘ server-side database programming ⓘ |
| runsIn |
Oracle Database
ⓘ
surface form:
Oracle Database server
|
| supports |
anonymous blocks
ⓘ
collections ⓘ conditional statements ⓘ control structures ⓘ cursors ⓘ exceptions ⓘ loops ⓘ modular programming ⓘ packages ⓘ records ⓘ stored functions ⓘ stored procedures ⓘ triggers ⓘ user-defined types ⓘ |
| supportsExecutionEnvironment |
Oracle Application Express
ⓘ
Oracle Forms ⓘ Oracle Reports ⓘ |
| usedWith |
Oracle Data Guard
ⓘ
Oracle Real Application Clusters (RAC) ⓘ
surface form:
Oracle Real Application Clusters
|
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: PL/SQL Description of subject: PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
Referenced by (5)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Oracle PL/SQL
this entity surface form:
Oracle PL/SQL