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
- 8 Answers
- 10198 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
The select into statement is most often used to create backup copies of tables or for archiving records?
Why procedure is used in sql?
Is ms sql traffic encrypted?
Explain what is rdbms?
What will you get by the cursor attribute sql%found?
Can 2 queries be executed simultaneously in a distributed database system?
What is sorting in sql?
What is the use of sql trace?
how to rename an existing column in a table? : Sql dba
How many sectors are in a partition?
what is user defined functions? : Sql dba
Why do we need cursors in pl sql?
Sql technical questions
How does a trigger work?
Are stored procedures compiled?
