What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

How to retrieve 5th highest sal from emp table?

8 Answers  

---

How to get a list of all tables in the database?

1 Answers  

---

Can we call a trigger inside a function and function inside a trigger? Give example.

1 Answers   Metric Stream,

---

What happens if the update subquery returns multiple rows?

0 Answers  

---

What are named parameters?

0 Answers  

---

Difference between pre-select and pre-query

0 Answers  

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

What is the difference between count (*), count (expression), count (distinct expression)?

0 Answers  

---

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

4 Answers   Microsoft, Wipro,

---