Explain For In 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

Solution 1:

A SQL statement is a string, but you have to use dynamic SQL to convert a SQL statement that is stored as a string.

FOR i IN (SELECT t.test
            FROM TESTING t) LOOP
   EXECUTE IMMEDIATE 'EXPLAIN PLAN FOR '|| i.test ||'';
END LOOP;

Reference:

• EXECUTE IMMEDIATE

Solution 2:

EXEC IMMEDIATE 'EXPLAIN PLAN FOR ' || TESTING.TEST