1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

What is nvl?

0 Answers  

---

what is a database lock ? : Sql dba

0 Answers  

---

Is sql a case sensitive language?

0 Answers  

---

What is Primary Key?

4 Answers   Ramco,

---

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

How insert into statements in 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,

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

Does group by remove duplicates?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

How do I sort a table in sql?

0 Answers  

---