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;
/
Is This Answer Correct ? | 28 Yes | 4 No |
Post New Answer View All Answers
What is plpgsql language?
Can we delete column in sql?
does sql support programming? : Sql dba
What is view? Can we update view
Which is faster subquery or join?
what is sql server agent? : Sql dba
What is normalization in a database?
What is sql analyzer?
Is trigger a stored procedure?
Is subquery faster than join?
How to select unique records from a table?
How do you pronounce sql?
Explain what is a subquery ?
Is sql a backend?
How global cursor can be declare with dynamic trigger ?