Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Computation or Process ?

user134954Mar 28 2013 — edited Apr 9 2013
Hi there,

I have the following values in my variable :P4_Linie

-9:TEST1:TEST2:TEST3

Now I know how to convert the ":" into "," and how to replace the -9. The -9 is the "all selector" of a checkbox pluging meaning if all checkboxes are checked the value -9 is given before the checkboxes data so sometimes it is there and sometimes not.

I know how to do this in a select statement:
SELECT *  FROM mv_auswertung WHERE INSTR (
          REPLACE (:P4_LINIE, '-9', '')
          ':'||Linie||':') > 0
Now I get TEST1,TEST2,TEST3 and now I can use this in a select into query.

But I need apex to do this via PL/SQL process or computation so the item is given to the next page in my items to submit.

I need to submit TEST1,TEST2,TEST3 for my IR. Hoping you can help.

Thx in advance

Thorsten

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2013
Added on Mar 28 2013
15 comments
414 views