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 t sql in sql server?

1053

---

Why select is used in sql?

999

---

What is the difference between partitioning and sharding?

989

---

When can we use the where clause and the having clause?

1006

---

Define a temp table?

999

---

What does 0 mean in sql?

949

---

Why do we need unique key in a table?

938

---

Is and as keyword in pl sql?

942

---

Is grant a ddl statement?

886

---

Can we rollback after truncate?

1012

---

What is $$ in sql?

970

---

What is the difference between a database and a relational database?

1081

---

What is the use of double ampersand (&&) in sql queries? Give an example

1122

---

how do you know if your mysql server is alive? : Sql dba

1060

---

explain the advantages and disadvantages of stored procedure? : Sql dba

988

---