Explain the difference between drop and truncate commands in sql?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

What does fetching a cursor do?

0 Answers  

---

How will we see framework of a table?

2 Answers   Accenture,

---

what is a view? : Sql dba

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  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

---

How do I partition a table in sql?

0 Answers  

---

What is a sql select statement?

0 Answers  

---