select count(*) from( select trim(regexp_substr(initcap(phoneno),'[^,

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 / kavitha nedigunta

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

Answer Posted / kavitha nedigunta

select count(*) from(
select trim(regexp_substr(initcap(phoneno),'[^,]+',1,level)) as phoneno
from testphone
connect by level <= length(regexp_replace(phoneno,'[^,]'))+1
)a

it will work in oracle 10g on words.

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different joins used in sql?

1055

Is sql better than excel?

1152

What are the types of sql commands?

1101

What does joining a thread mean?

1019

How do you create a db file?

1016

What is scalar data type in pl sql?

1068

What is break?

1197

What are views in sql?

986

What is nosql example?

1034

how to shut down the server with 'mysqladmin'? : Sql dba

1012

What are pl sql data types?

1009

How to run pl/sql statements in sql*plus?

1079

What is cursor and why it is required?

1183

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1125

what is the difference between char and varchar data types? : Sql dba

1108