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
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
Explain what is sql?
What is the purpose of a sql?
What are crud methods?
What are the packages in pl sql?
Can we use delete in merge statement?
Does inner join remove duplicates?
what is oltp (online transaction processing)? : Sql dba
What is the best sql course?
How do you create an update query?
What's the procedure?
Why left join is used in sql?
Is primary key an index?
Why do we use procedures in pl sql?
What is auto increment?
What is a dynamic query?