Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

what is foreign key? : Sql dba

0 Answers  

---

sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)

1 Answers   Fidelity, Oracle,

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

What is pivot in sql?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

What do you mean by rowid?

0 Answers  

---

What are the types of variable use in pl sql?

0 Answers  

---

what is an index? : Sql dba

0 Answers  

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

---