pls send me pl/sql script also

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

Question Posted / ram

6 Answers
8637 Views
I also Faced
E-Mail Answers

Answer Posted / ram

pls send me pl/sql script also

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger price?

995

what is unique key constraint? : Sql dba

1042

what are the advantages of mysql in comparison to oracle? : Sql dba

1005

Why do we use triggers?

972

what are aggregate and scalar functions? : Sql dba

1058

State few characteristics of pl/sql?

971

What are the parts of a basic sql query?

968

Why do we use set serveroutput on?

969

define sql delete statement ? : Sql dba

1024

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1193

How does rowid help in running a query faster?

1417

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

999

Define implicit and explicit cursors.

1150

what is bcp? When is it used?

1115

define join and explain different type of joins? : Sql dba

954