How many times can we commit in a loop?

0 Answers  

---

Can we rollback truncate?

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---

What is the difference between view and stored procedure?

0 Answers  

---

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---

---

how many ways to get the current time? : Sql dba

0 Answers  

---

Write an sql query to select all records from the table?

0 Answers  

---

How to avoid using cursors?

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 pls give me answer. i want urgent

6 Answers  

---

Why is partition used in sql?

0 Answers  

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---

How many joins can you have in sql?

0 Answers  

---