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!

Dynamic Where Clause - How To?

450042Sep 20 2005 — edited Mar 3 2006
I need help building a dynamic where clause in 1.6

I have three fields:
p1_col_where which is a static list of 8 columns
p1_condition which is a static list of the 9 possible conditions(=,<,>...)
p1_condition_value is a text field that the user enters the literal they want to use

The lov select I thought would be:
SELECT Description, positem
FROM v_item
WHERE :P1_COL_WHERE :P1_CONDITION :P1_CONDITION_VALUE

I was hoping that this would be resolved to: WHERE item = 123
but of course I get a big NASTY error.

Can someone help me out?

Thanks,
Joe
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2006
Added on Sep 20 2005
13 comments
965 views