List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

what is a constraint? : Sql dba

0 Answers  

---

Is pl sql and postgresql same?

0 Answers  

---

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

---

what are rollup and cube in t-sql? : Transact sql

0 Answers  

---

What is normalisation and its types?

0 Answers  

---

What are the set operators in sql?

0 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

What is where clause in sql?

0 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

What is NOCOPY?

6 Answers   DELL,

---

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

---