select name,length(replace(phno, ',')) from phno;

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 / ajit

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

Answer Posted / ajit

select name,length(replace(phno, ','))
from phno;

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 lookup table in sql?

1094

how many ways to get the current time? : Sql dba

1048

What is a unique key?

1106

How do I turn a list into a table?

1013

How to get unique records from a table?

1024

What are the different types of triggers?

1195

Does inner join remove duplicates?

1005

How do you determine the current isolation level? : Transact sql

1206

what are the different functions in sorting an array? : Sql dba

1068

Explain how exception handling is done in advance pl/sql?

1047

Does sql view stored data?

1003

what is the difference between primary key and unique key? : Sql dba

1086

What are the uses of sysdate and user keywords?

1152

How can one get sql*loader to commit only at the end of the load file? : aql loader

1120

Write an sql query to select all records from the table?

1081