Thread: retrieve subqueries information
02-06-04, 16:37 #1Registered User
- Join Date
- Feb 2004
Unanswered: retrieve subqueries information
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?