How many aggregate functions are available there in sql?

0 Answers  

---

How to return multiple rows from the stored procedure?

0 Answers  

---

How many types of sql are there?

0 Answers  

---

What is trigger in pl sql?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

---

What are the two types of cursors in pl sql?

0 Answers  

---

Show the cursor attributes of pl/sql.

0 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

How many developers work on postgresql?

0 Answers  

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

What is lookup table 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,

---