Skip to Main Content

Oracle Database Discussions

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!

AQ: How to query user_data?

fschulzeApr 20 2010 — edited Apr 20 2010
Hi,

I want to query my queue_table.user_data column.
I must find out whether there is an entry in the queue depending of the payload.

(I imagined something like this:

select str_value
from queue_table qt
where qt.user_data.???.??? (myPayloadField) = '123')

How can I achieve this?

thx,
Florian.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2010
Added on Apr 20 2010
3 comments
8,964 views