Overcoming the Limitations:

Therefore, the package DBMS_SQL that is supplied with Oracle permits PL/SQL to execute SQL data definition and data manipulation statements dynamically at run time.

Open_Cursor

For process a SQL statement, you have to an open cursor. Whenever you call the OPEN_CURSOR function you receive a cursor ID number for the data structure representing a valid cursor maintained through Oracle.

Parse

Every SQL statement must be parsed by calling the PARSE procedure. A Parsing is the statement checks the statement's syntax and relates it with the cursor in your program

You can parse any data manipulation language or data definition language statements. DDL Data definition language  statements  are  executed  on  the  parse,  that  performs  the  implied commit.

Execute

Execute function execute your SQL statement.

CLOSE_CURSOR

When you no longer required a cursor for a session, close the cursor by calling CLOSE_CURSOR.