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
- 10237 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to display Row Number with Records in Oracle SQL Plus?
What is dynamic query?
How many postgresql users are there, worldwide?
Explain normalization and what are the advantages of it?
How do you identify a primary key?
Difference between global and parameter variables?
Why are sql stored procedures used?
Where do we use pl sql?
What is primary and foreign key?
How do I create an index in word?
what is a join? : Sql dba
What does trigger mean in psychology?
Which are sql * plus commands?
What are inner and outer joins examples of both?
What is a scalar value in sql?
