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
11029 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 has stored procedures in sql?

996

what is an alias command? : Sql dba

1011

How can we debug in PL/SQL?

1094

what are the different type of normalization? : Sql dba

974

What is field delimiter?

991

What is the usage of the distinct keyword?

1169

What is cte sql?

930

Can you upgrade sql express to full sql?

996

List the various privileges that a user can grant to another user?

990

Can a table have no primary key?

1011

What are field types?

943

Explain the structure of pl/sql in brief.

1044

How many tables can a sql database have?

927

How does sql store data?

867

Explain the purpose of %type and %rowtype data types with the example?

929