Explain the difference between triggers and constraints?

0 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

---

Explain the rollback statement?

0 Answers  

---

Is null operator 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 are the advantages of cursors than procedures?

2 Answers  

---

Are sql connections encrypted?

0 Answers  

---

Why use truncate instead of delete?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

---

What are all the different normalizations?

0 Answers  

---