a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

What is minus?

0 Answers  

---

What is the use of sqldataadapter?

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 is compute?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---

Why is the cursor important?

0 Answers  

---

When is the update_statistics command used?

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

What are triggers and its uses?

0 Answers  

---