Pre-defined collection types in Oracle
In his comment, Gary alerts me of the fact that Oracle has a pre-defined collection type called dbms_debug_vc2coll. It is owned by sys and granted to public. I have also discovered that there is another pre-defined collection type called ku$_vcnt and it is also owned by sys and granted to public. However, ku$_vcnt is a table of varchar2(4000), whereas dbms_debug_vc2coll is a table of varchar2(1000):
(more…)
