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;
/

What is the difference between delete and truncate statement in sql?

1008

---

What is a database event trigger?

1080

---

Sql technical questions

1201

---

What is a memo field?

900

---

How does a trigger work?

987

---

what is bcp? When is it used?

1046

---

Explain the working of primary key?

1034

---

What is normalisation in sql?

1002

---

What does pl sql stand for?

1062

---

What is substitution variable in pl sql?

978

---

How do I create a sql database?

947

---

Is big data nosql?

886

---

What is time based sql injection?

900

---

What is informix sql?

921

---

Can we debug stored procedure?

956

---