1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Can we write create command in the plsql block?if possible
how?

Question Posted / aparna

Answers were Sorted based on User's Feedback



Can we write create command in the plsql block?if possible how?..

Answer / umadevi

yeah the above answer is correct..

begin
execute immediate 'create table tablename(column_name
coloumn_type(coloumn_length))';
end;

Is This Answer Correct ?    11 Yes 0 No

Can we write create command in the plsql block?if possible how?..

Answer / sidh

Yes We can write a create command in a PL/SQL block using
dynamic SQL

eg Execute immediate 'create table tab_name....'

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why query optimization is needed?

0 Answers  

What is the difference between join and natural join?

0 Answers  

What's the difference between a primary key and a clustered index?

0 Answers  

What is meant by truncate in sql?

0 Answers  

What are the popular database management systems in the it industry?

0 Answers  




How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

What is sqlcontext?

0 Answers  

What information is needed to connect sql*plus an oracle server?

0 Answers  

Do ddl statements need commit?

0 Answers  

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

What is pl/sql and what is it used for?

4 Answers  

Does a join table need a primary key?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories