What is the purpose of the partition table?

0 Answers  

---

Can we use ddl commands in pl sql?

0 Answers  

---

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 will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

What is full join in sql?

0 Answers  

---

What is the difference between inner join and outer join?

0 Answers  

---

Can we rollback delete command?

0 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

what are numeric data types? : Sql dba

0 Answers  

---

What is a temporal table?

0 Answers  

---

What is offset in sql query?

0 Answers  

---