EXPLAIN PLAN FOR in ORACLE
- by Adnan
I am making a test. I have all tests in rows, so my rows looks like this;
ID | TEST
----------------------------------
1 | 'select sysdate from dual'
2 | 'select sysdatesss from dual'
Now I read it row by row and I need to test it with EXPLAIN PLAN FOR
so the for the first row it would be
EXPLAIN PLAN FOR select sysdate from dual
but I have problem converting the TEST field. Right now I use;
EXPLAIN PLAN FOR testing.TEST
but it does not work.
Any ideas?
