Log-In to post
This procedure allows you to execute a DDL statement easily.
(parse_string IN VARCHAR2);
Here, for example, is all the code you need to write to create an index from within PL/SQL:
('create index so_easy on emp (hiredate, mgr, sal)');
You can also use the DBMS_SQL package to perform the same functionality.