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

What is linq to sql?

0 Answers  

What is difference between group by and partition by?

0 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

What are the benefits of triggers?

0 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

What is trigger and types?

0 Answers  

What are the qualities of 2nf?

0 Answers  

What is trigger types of trigger?

0 Answers  

What is character functions?

0 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,