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!
Hi All,
I have a ROWID and I want to find row in table using the rowid but it's not giving me anything.
SELECT *
FROM ont.oe_order_lines_all a
JOIN (
SELECT TO_CHAR ('AAAKHvAA0AAN38+AAB') rid
FROM dual
) b ON b.rid = a.rowid;