Answer Posted / umadevi

yeah the above answer is correct..

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

How do sql databases work?

944

---

Why do we use cursors?

919

---

Define the select into statement.

992

---

How to get each name only once from an employee table?

1062

---

what is view? : Sql dba

912

---

what is the difference between $message and $$message? : Sql dba

943

---

How to convert comma separated string to array in pl/sql?

1111

---

What is cold data?

897

---

What is a common use of group by in sql?

995

---

How to use transactions efficiently : transact sql

991

---

What is sqlcontext?

986

---

Which is faster subquery or join?

1144

---

What is the difference between function and procedure in pl/sql?

1014

---

What are conditional predicates?

987

---

Explain what is rdbms?

991

---