Well, there are some drawbacks to dbms_utility.comma_to_table.
The first is that it's a procedure rather than a function, so you can't use it in SQL.
The second, as discussed on AskTom, is that it is not designed as a general purpose "split" function, but as something rather specialised for parsing lists of materialized view names in mview groups, so it will reject any string that starts with a number, contains spaces etc.
2 Comments:
Also useful.
I have also found dbms_utility.comma_to_table very useful in converting comma separated lists back and forth betwenn csv and plsql tables.
Well, there are some drawbacks to dbms_utility.comma_to_table.
The first is that it's a procedure rather than a function, so you can't use it in SQL.
The second, as discussed on AskTom, is that it is not designed as a general purpose "split" function, but as something rather specialised for parsing lists of materialized view names in mview groups, so it will reject any string that starts with a number, contains spaces etc.
Post a Comment
Links to this post:
Create a Link
<< Index of articles