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
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 do you delete data from a table?
Can there be more than one function with a similar name in a pl/sql block?
Explain the uses of database trigger.
Can we use ddl commands in pl sql?
Can a key be both primary and foreign?
What are types of joins?
Can we insert data into materialized view?
What is delete command in sql?
Can %notfound return null after a fetch?
How many sql commands are there?
What is the difference between python and sql?
What is character functions?
What is memory optimized table?
What are reports usually used for?
Define select, insert, create, delete, update, drop keywords