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
11604 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 is subquery? : Sql dba

1192

Is id a reserved word in sql?

1193

Give the order of sql select?

1187

Define the select into statement.

1114

Can I call a procedure inside a function?

1076

what is the difference between delete and truncate statement in sql? : Sql dba

1351

What is the maximum rows in csv?

979

What is a sql*loader control file?

1346

Which sql statement is used to return only different values?

1059

What are different types of indexes?

1058

What is a table?

1062

Explain how can you save or place your msg in a table?

1078

What normalization means?

1017

What is a sql statement?

1020

Is sql port 1433 encrypted?

1089