Starting from Oracle 8i one can use the " EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL ...
www.orafaq.com