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:
from queue_table qt
where qt.user_data.???.??? (myPayloadField) = '123')
How can I achieve this?
thank you, aychin!
It's working for me now.
I've also found another way:
FROM (SELECT (SELECT str_value
FROM TABLE (qt.user_data.HEADER.properties)
WHERE NAME = 'DKT_ID') dkt_id
FROM my_queue_table qt)
WHERE dkt_id = '123'
Edited by: fschulze on Apr 20, 2010 4:02 PM