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

how to shutdown mysql server? : Sql dba

1082

How does left join work in sql?

985

What does select * from mean in sql?

3187

What are the advantages of normalization?

1068

What are different functions in sql?

925

What does count (*) do in sql?

984

what is a cursor? : Sql dba

1002

How do you modify a table in sql?

1107

Why coalesce is used in sql?

982

How do I view a sql database?

1007

What is primary key and foreign key?

947

What program will open a mdb file?

948

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1569

What is sqlexception in java?

967

What is dialect in sql?

925