From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

---

Do foreign keys improve performance?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

What is use of trigger?

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 do I delete a trigger?

0 Answers  

---

What does trigger mean in psychology?

0 Answers  

---

How to install oracle sql developer?

0 Answers  

---

Can we use update in sql function?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What is type and rowtype in pl sql?

0 Answers  

---