Answer / umadevi

yeah the above answer is correct..

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

Answer / sidh

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

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

What is trigger and stored procedure in sql?

0 Answers  

---

What are keys in sql?

0 Answers  

---

Is primary key an index?

0 Answers  

---

Do stored procedures prevent sql injection?

0 Answers  

---

What is the use of sqldataadapter?

0 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

How can you select unique records from a table?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

How many types of privileges are available in sql?

0 Answers  

---

What is difference between sql function and stored procedure?

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---