Toad World® Forums

How to avoid the error when using apex_string.split

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.