select count(&a) from emp enter the column name at run time it will

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

8 Answers
11024 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

Please Help Members By Posting Answers For Below Questions

What are the advantages of stored procedure?

946

What is an emotional trigger?

930

Why is pl sql needed?

874

Can we edit a view in sql?

925

How do you update a sql procedure?

970

Can 2 queries be executed simultaneously in a distributed database system?

1082

Can we use views in stored procedure?

968

What is the difference between python and sql?

938

What is meant by temporal data?

904

What is row_number () in sql?

933

How to return an array from java to pl/sql?

1061

What are the properties of a transaction?

1072

Is sql dba a good career? : SQL DBA

939

Describe sql comments?

959

What are all different types of collation sensitivity?

973