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

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 / ajit

8 Answers
11231 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / ajit

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference sql and mysql?

966

what are the t string functions available in tsql? : Transact sql

990

How many types of index are there?

1019

How many types of triggers exist in pl/sql?

1048

How to display Row Number with Records in Oracle SQL Plus?

1025

What is procedure explain with program?

994

What is sequence in sql?

987

Can a table contain multiple primary key’s?

1078

What is the use of %rowtype?

1024

What is trigger point?

976

What do you mean by field in sql?

1068

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1010

What is orm in sql?

1030

What is oracle pl sql developer?

963

what is view? : Sql dba

939