Explain the update statement in sql

0 Answers  

---

What is difference between procedure and trigger?

0 Answers  

---

What are all the ddl commands?

0 Answers  

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

what is online transaction processing (oltp)? : Sql dba

0 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

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,

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

how is exception handling handled in mysql? : Sql dba

0 Answers  

---

How to use sql*plus built-in timers?

0 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---