how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 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,

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

what is sql profiler? : Sql dba

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

what are the advantages a stored procedure? : Sql dba

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

What is on delete set null?

0 Answers  

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

---

What are the different types of triggers?

0 Answers  

---