What is procedure explain with example?

0 Answers  

---

What are the main features of cursor?

0 Answers  

---

What are the types of variable use in pl sql?

0 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,

---

Why is theta join required?

0 Answers  

---

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

What is example of database?

0 Answers  

---

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---

What is transaction control language (tcl)?

0 Answers  

---

Can we call stored procedure in function?

0 Answers  

---

What's the procedure?

0 Answers  

---

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

---