Statements (25)
Predicate | Object |
---|---|
gptkbp:instanceOf |
SQL feature
|
gptkbp:alternativeTo |
user-defined functions
views common table expressions |
gptkbp:canBe |
subqueries
SELECT statements FROM clauses JOIN conditions WHERE clauses |
gptkbp:compatibleWith |
gptkb:MySQL
gptkb:PostgreSQL gptkb:SQL_Server |
gptkbp:definedWith |
gptkb:PL/SQL
|
gptkbp:documentation |
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-FUNCTION.html#GUID-2B2B6B2A-2B2B-4B2B-8B2B-2B2B6B2A2B2B
|
gptkbp:enables |
dynamic SQL generation
parameterized SQL expressions |
https://www.w3.org/2000/01/rdf-schema#label |
SQL Macros
|
gptkbp:introducedIn |
gptkb:Oracle_Database_19c
|
gptkbp:purpose |
code reuse in SQL
simplify complex queries |
gptkbp:supportedBy |
gptkb:Oracle_Database
|
gptkbp:type |
scalar macro
table macro |
gptkbp:bfsParent |
gptkb:Oracle_Database_23c
|
gptkbp:bfsLayer |
7
|