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 does a self join work?

1127

---

Is primary key is clustered index?

1002

---

What is the use of triggers?

1037

---

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

---

Can triggers stop a dml statement from executing on a table?

1098

---

What is view explain with example?

931

---

describe mysql connection using mysql binary. : Sql dba

1068

---

What is a null value?

1144

---

What is scalar function?

1054

---

what is row? : Sql dba

1228

---

What found sql?

944

---

Enlist some predefined exceptions?

1060

---

Difference between global and parameter variables?

1968

---

What do you mean by field in sql?

1077

---

How does cross join work in sql?

1018

---