Dynamic statement

Using dynamic SQL statements from PL/SQL

Sometimes you need to execute dynamic SQL statements. Starting with Oracle8i, you can accomplish this task using the EXECUTE IMMEDIATE statement. Here are three examples of how you can take…