Answer / Meena Kumari

A subquery in SQL is a query that is nested within another SQL statement. It returns a result that is used as part of the WHERE, HAVING, or JOIN clauses of an outer query.

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

What is schema in sql example?

1 Answers  

---

What is rowtype?

1 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

1 Answers  

---

can i call procedure in package

3 Answers   TCS,

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

how do you control the max size of a heap table? : Sql dba

1 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

How can a function retun more than one value in oracle with proper example?

1 Answers  

---

Is it possible for a table to have more than one foreign key?

1 Answers  

---

How do I view a sql trace file?

1 Answers  

---

how can we submit a form without a submit button? : Sql dba

1 Answers  

---