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
11362 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

Explain the difference between sql and mysql.

1066

What are the types of records?

989

What is a string data type in sql?

1046

Is time a data type in sql?

911

What is sql and db2?

1011

What is gpt format?

943

Why do we use procedures in pl sql?

1045

What are the uses of merge?

1167

Do prepared statements prevent sql injection?

953

What does trigger mean in slang?

1065

What are the different types of tables in sql?

1009

what are the authentication modes in sql server? : Sql dba

1067

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1095

Can I create table without primary key?

1002

How do you declare a variable in pl sql?

1032