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
- 8 Answers
- 9772 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / nitin vartak
select enam ,eempno , (len(phoneno) - len(replace
(phoneno,',',''))) + 1 from TableName
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Enlist the characteristics of pl/sql?
What is inner join in sql?
What is sql keyword?
What are the parts of a basic sql query?
How do I trace sql profiler?
what is the difference between nested subquery and correlated subquery?
what is the syntax for using sql_variant_property? : Transact sql
What is the difference between null value, zero, and blank space?
What is attribute indicator in pl sql?
What is the difference between left join and right join?
What does cursor do in sql?
How to write html code in pl sql?
How do I partition a table in sql?
what is 'mysqlcheck'? : Sql dba
What do we need to check in database testing?
