Oracle SQL Tip: Using dbms_debug_vc2coll and sys.ODCIVarchar2List

They say examples are the best way to learn: Example 1:

Example 2:

Simply put, Oracle has pre-defined types that allow you to dynamically convert a comma-separated list of values into rows. Now you can join with another table or tables in a sql query. We had a programming task where a list Read more about Oracle SQL Tip: Using dbms_debug_vc2coll and sys.ODCIVarchar2List[…]