Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11366 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
what are myisam tables? : Sql dba
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is pl/sql table? Why it is used?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is a primary key example?
What operating systems are supported by oracle sql developer?
how to decrement dates by 1 in mysql? : Sql dba
How is a PL/SQL code compiled?
What is an intersect?
How do I count duplicates in sql?
How many clustered indexes can you have?
What is difference between pl and sql?
What are the types of index in sql?
what is the difference between undefined value and null value? : Sql dba
What is sql and explain its components?
