I want to retrieve all the subqueries used for a particular DML statement.
ex. if i have an update stmt
UPDATE tableA set feild1=....
where field2= (... subquery...)
I want to retrieve this subquery alone at runtime in a pl/sql procedure.
IS there a way to do it?