Answer Posted / pavan_1981

One can call DDL statements like CREATE, DROP, TRUNCATE,
etc. from PL/SQL by using the "EXECUTE IMMEDATE" statement.
Users running Oracle versions below 8i can look at the
DBMS_SQL package .
begin
EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)';
end;
NOTE: The DDL statement in quotes should not be terminated
with a semicolon.

Another way is One can also use the older DBMS_SQL package
(V2.1 and above) to execute dynamic statements. Look at
these examples:
CREATE OR REPLACE PROCEDURE DYNSQL AS
cur integer;
rc integer;
BEGIN
cur := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(cur, 'CREATE TABLE X (Y DATE)',
DBMS_SQL.NATIVE);
rc := DBMS_SQL.EXECUTE(cur);
DBMS_SQL.CLOSE_CURSOR(cur);
END;
/

how to use like conditions? : Sql dba

1100

---

how tsql statements can be written and submitted to the database engine? : Transact sql

974

---

what are the differences between require and include, include_once and require_once? : Sql dba

1017

---

What is substitution variable?

1042

---

What does select top 1 do in sql?

1084

---

What is $$ in sql?

983

---

Why is stored procedure faster than query?

948

---

What is sorting in sql?

936

---

What is the primary key?

945

---

What are the steps for performance tuning.

1326

---

How do I audit the sql sent to the server?

1000

---

How many types of primary keys are there?

1028

---

What are the built in functions of sql?

1025

---

what are string data types? : Sql dba

1037

---

What is serial sql?

966

---