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

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

1001

What is input buffer in sql*plus?

1293

what is a database transaction? : Sql dba

1258

What is linq to sql?

1183

What is the most important ddl statements in sql are?

1046

Does sql support programming?

1118

Can we use having without group by in sql?

1054

What are the types of queries in sql?

1133

What are the benefits of stored procedures?

1130

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273

Difference between global and parameter variables?

2020

Explain architecture of sql server notification services?

1117

What are the operators in sql?

1073

what is 'trigger' in sql? : Sql dba

1149

What is the meaning of disabling a trigger?

1243