1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / ramkrish.143

Answers were Sorted based on User's Feedback



i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

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.

Is This Answer Correct ?    6 Yes 1 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

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

Is This Answer Correct ?    5 Yes 0 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

Answer / nitin vartak

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

Is This Answer Correct ?    5 Yes 3 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

Answer / ajit

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

Is This Answer Correct ?    0 Yes 0 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

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;

Is This Answer Correct ?    3 Yes 4 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

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.

Is This Answer Correct ?    2 Yes 4 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

Answer / ajmal khan

select count(column_name) from table_name;

Is This Answer Correct ?    0 Yes 3 No

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87..

Answer / sanjeev

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

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

What are sql indexes?

0 Answers  

Is primary key always clustered index?

0 Answers  

Does indexing improve query performance?

1 Answers  




What is oracle sql called?

0 Answers  

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

what is view? : Sql dba

0 Answers  

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

How can I get the number of records affected by a stored procedure?

0 Answers  

How does a self join work?

0 Answers  

Which software is used for pl sql programming?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories