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 self join and why is it required? : Sql dba

1 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1 Answers  

---

How do you determine the current isolation level? : Transact sql

1 Answers  

---

Why function is used in sql?

1 Answers  

---

Can a table contain multiple foreign key’s?

1 Answers  

---

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 Answers  

---

What are the types of variable use in pl sql?

1 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

what are properties of a transaction? : Sql dba

1 Answers  

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

what is foreign key? : Sql dba

1 Answers  

---