Answer / 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.

Answer / sarath

select length(phoneno)-length(replace(phoneno,','))+1 as TOTALCOUNT from <tablename>

For few friends who sent count(*) I wanna say something that
Its a SINGLE (FIELD VALUE)STRING CONTAINING MULTIPLE PHONENOs

Answer / nitin vartak

select enam ,eempno , (len(phoneno) - len(replace
(phoneno,',',''))) + 1 from TableName

Answer / ajit

select name,length(replace(phno, ','))
from phno;

Answer / venkat

select count(column_name) from table_name;

if u want to count number of phone numbers then use below
from emp table

select count(phno) from emp;

Answer / rolly

select count(&a) from emp

enter the column name at run time it will give the exact
count.

I have tested it. It works.

Answer / ajmal khan

select count(column_name) from table_name;

Answer / sanjeev

select ename,empno,count(column name) from table name

Is join same as left join?

0 Answers  

What is difference between primary and secondary key?

0 Answers  

Does sql view stored data?

0 Answers  

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

What is dbo in sql?

0 Answers  

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

How do you remove duplicate records from a table?

0 Answers  

What does the file extension accdb stand for?

0 Answers  

What does trigger mean in psychology?

0 Answers  

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

what is the difference between blob and text? : Sql dba

0 Answers