Hi,
I have this SQL and Toad (version 13.1) show the error as below, how to avoid it?
select * from apex_string.split('1:2:3',':')
Hi,
I have this SQL and Toad (version 13.1) show the error as below, how to avoid it?
select * from apex_string.split('1:2:3',':')
Hi hlthanh,
If you look at that function, you should see that it returns a table of values. Because Oracle by default deals in rows ("tuples"), you'll need to transform that table into rows first (SQL*Plus will also choke on your query). Luckily, Oracle has the TABLE function for you:
SELECT * FROM TABLE(apex_string.split('1:2:3',':'));
Enjoy!
Rich
Thanh you. It works for me now.