EXPLAIN PLAN FOR in ORACLE
Posted
by Adnan
on Stack Overflow
See other posts from Stack Overflow
or by Adnan
Published on 2010-05-31T14:45:31Z
Indexed on
2010/05/31
14:53 UTC
Read the original article
Hit count: 252
Oracle
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?
© Stack Overflow or respective owner