select length(phoneno)-length(replace(phoneno,','))+1 as TOTALCOU

i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6

Question Posted / sarath

8 Answers
11350 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / sarath

select length(phoneno)-length(replace(phoneno,','))+1 as TOTALCOUNT from <tablename>

For few friends who sent count(*) I wanna say something that
Its a SINGLE (FIELD VALUE)STRING CONTAINING MULTIPLE PHONENOs

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is case function?

1040

What version is sql?

1031

What operating systems are supported by oracle sql developer?

965

Can we insert data into view?

900

how to include comments in sql statements? : Sql dba

955

What is assignment operator in pl sql?

1035

Why is theta join required?

1145

Which function is used to return remainder in a division operator in sql?

1140

What is asqueryable?

969

What is sql character function?

1079

What plvcmt and plvrb does in pl/sql?

1323

What is #table in sql?

1098

What are the qualities of 2nf?

1039

What is structural independence and why is it important?

1031

What is the purpose of the partition table?

1049