APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using the result of string_to_table in SQL

Gareth SOct 29 2008 — edited Oct 29 2008

Hi,

Apologies if this has already been answered - I couldn't seem to get the right mix of search terms to find what I was looking for.

I'd like to know if there is a way to use the output or APEX_UTIL.string_to_table directly in SQL without any extra coding (I know I could create VARCHAR2 table type and CAST that to a table - essentially I'm wondering if this has already been done for you or not with APEX).

So the end query would be something like:

UPDATE my_table
   SET column_a = 12345
 WHERE my_id_column IN (SELECT column_value FROM TABLE(APEX_UTIL.string_to_table(:P1_MY_MULTISELECTLIST)));

Regards,

Gareth.

This post has been answered by ATD on Oct 29 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2008

Added on Oct 29 2008

#apex-discussions, #sql

10 comments

5,294 views