top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to call DDL statements in Oracle PL/SQL

+1 vote
177 views
How to call DDL statements in Oracle PL/SQL
posted Sep 15, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes
 
Best answer

begin
execute immediate 'create table emp1 as select * from emp';
end;
/

answer Sep 16, 2014 by Pradeep Kumar
+1 vote

BEGIN
EXECUTE IMMEDIATE ‘create table table1(no number(4),name varchar2(15))’;
END;

answer Sep 15, 2014 by Arun Gowda
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...