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

How do I copy a table in sql?

962

Why are cursors used?

1102

what is a constraint? Tell me about its various levels. : Sql dba

969

Is sql a scripting language?

968

What are triggers and its uses?

1030

What is exception? What are the types of exceptions?

1060

Can you join a table to itself?

1105

What is the maximum rows in csv?

910

how to return query output in html format? : Sql dba

1057

What are the benefits of pl sql?

1102

What is a parameter query?

1058

Does varchar need length?

977

What is sql mysql pl sql oracle?

1057

what is a control file ? : Sql dba

1017

When are we going to use truncate and delete?

964