What is the difference between partition and index?

0 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

How do you take the union of two tables in sql?

0 Answers  

---

How to return multiple rows from the stored procedure?

0 Answers  

---

What is 19 null in sql?

0 Answers  

---

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---

What is dialect in sql?

0 Answers  

---

Define implicit and explicit cursors.

0 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

2 Answers   Maruti Suzuki,

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

How do you declare a variable in pl sql?

0 Answers  

---