What are the different parts of a package?

0 Answers  

---

Are pl sql variables case sensitive?

0 Answers  

---

What is difference between group by and partition by?

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What are the different types of functions in sql?

0 Answers  

---

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 are procedures used for?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

Define commit?

0 Answers  

---

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

---

Can unique keys be null?

0 Answers  

---