Reusable SQL templates: learn about SQL Macros

CREATE TABLE planets (    json_document BLOB,    CONSTRAINT json_document_is_json CHECK (json_document IS JSON));INSERT INTO planets (json_document) VALUES ( '[ {"name":"Mercury"}, {"name":"Venus"}, {"name":"Earth"},             {"name":"Mars"}, {"name":"Jupiter"}, {"name":"Saturn"},             {"name":"Uranus"}, {"name":"Neptune"} ]' );COMMIT;-- One row retrieved containing a JSON arraySELECT JSON_SERIALIZE(json_document) AS array FROM planets;                                                       ARRAY-------------------------------------------------------------[ {"name":"Mercury"}, {"name":"Venus"}, {"name":"Earth"},  ]CREATE FUNCTION unwind(jsonTable DBMS_TF.TABLE_T)       RETURN VARCHAR2 SQL_MACRO ISBEGIN    RETURN q'{SELECT d.array_item AS JSON_DOCUMENT, d.order_id                FROM unwind.jsonTable NESTED json_document COLUMNS (                     NESTED PATH '$[*]' COLUMNS (                         array_item CLOB FORMAT JSON PATH '$',                         order_id FOR ORDINALITY ) ) d }';END;/SELECT * FROM unwind(planets);              JSON_DOCUMENT   ORDER_ID------------------ ----------{"name":"Mercury"}          1  {"name":"Venus"}          2  {"name":"Earth"}          3   {"name":"Mars"}          4{"name":"Jupiter"}          5 {"name":"Saturn"}          6 {"name":"Uranus"}          7{"name":"Neptune"}          8