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
11590 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 is a system versioned table?

1043

Can we change the table name in sql?

1005

Is delete faster than truncate?

1052

Can we use ddl commands in pl sql?

1235

What is a constraint? Tell me about its various levels.

1250

What is the location of pre_defined_functions.

1211

What is example of database?

1134

What is the difference between Union and Union all. Which is faster.

1441

Can one improve the performance of sql*loader? : aql loader

1099

Is join an inner join?

1026

What does the file extension accdb stand for?

1017

What is an inner join sql?

1099

What is sql indexing?

1065

what are the types of subquery? : Sql dba

1161

What is identity column in sql server?

1102