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

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

how to rename an existing table in mysql? : Sql dba

0 Answers  

---

What is sharding in sql?

0 Answers  

---

how view used for security purposes?

3 Answers   Glam India,

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

What is pl sql variable?

0 Answers  

---

What is break?

0 Answers  

---

Can we join same table in sql?

0 Answers  

---

What is consistency?

0 Answers  

---

What are different types of joins ?

5 Answers   BirlaSoft,

---

What is memory optimized table?

0 Answers  

---