Macros in Oracle #SQL enable you to define expression templates as text
At parse time the database merges these with the parent query, replacing parameters with the actual values passed
Macros come in two types
Scalar - use in SELECT, WHERE, ORDER BY, etc.
Table - use in FROM
2 days ago