SQL Macros

GPTKB entity

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