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....'

Can we use pl sql in sql server?

0 Answers  

---

Define implicit and explicit cursors.

0 Answers  

---

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

---

Are views faster than queries?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

what are sequences

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is the difference between join and natural join?

0 Answers  

---

What is pl sql architecture?

0 Answers  

---

What are packages in pl sql and also explain its advantages?

0 Answers  

---

Is foreign key mandatory?

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---