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: 229

Filed under:

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

Related posts about Oracle