PIPELINED FUNCTION – how to get data dynamically

The resulting SQL query in Oracle database is up to dynamically influence/generate a so called pipelined FUNCTION. Their use, we will see the following example: [Česká verze článku – PIPELINED FUNCTION aneb jak na data dynamicky] Create new data types PersonType and PersonTypeSet Within these data types, we store our data. Create a pipelined FUNCTION…