Statements (25)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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 |
| 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
|
| https://www.w3.org/2000/01/rdf-schema#label |
SQL Macros
|