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

Why use triggers in sql?

0 Answers  

How do I tune a sql query?

0 Answers  

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

What is difference between stored procedure and trigger?

0 Answers  

Can a primary key be a foreign key?

0 Answers  

What are the constraints available in sql?

0 Answers  

What is the command used to fetch first 5 characters of the string?

0 Answers  

How did you export data from database to excel file.

1 Answers   TCS,

What is sql deadlock?

0 Answers  

Is sql open source?

0 Answers  

How to call a javascript function from pl sql?

0 Answers  

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers