What does “select count(*) from tab” result?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / vinod

15 Answers
29026 Views
IBM, Student, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What does “select count(*) from tab” result? ..

Answer / sudheer

Will display the count of the Tables on the Schema.

Is This Answer Correct ?

22 Yes

4 No

What does “select count(*) from tab” result? ..

Answer / rahul koshti

This results the total count of tables,views,synonyms and
sequences present in a schema.

Is This Answer Correct ?

19 Yes

3 No

What does “select count(*) from tab” result? ..

Answer / ashwin

No of tables and views in schema...........i've tasted
it........

Is This Answer Correct ?

1 Yes

0 No

What does “select count(*) from tab” result? ..

Answer / deepshikha

it will result the count of TABLE,CLUSTER,VIEW,SYNONYM
in given schema

Is This Answer Correct ?

3 Yes

3 No

What does “select count(*) from tab” result? ..

Answer / nisha

This results the total count of tables,views,synonyms
present in a schema.

Is This Answer Correct ?

3 Yes

4 No

What does “select count(*) from tab” result? ..

Answer / umesh h

suppose a table is there with the name tab
then count of rows in that table will be displayed.
else count of all the logical objects under one schema
will be displayed.

Is This Answer Correct ?

3 Yes

4 No

What does “select count(*) from tab” result? ..

Answer / vijay

it will result number of records in a table

Is This Answer Correct ?

3 Yes

4 No

What does “select count(*) from tab” result? ..

Answer / a

It will not return the data dictionary tables

Is This Answer Correct ?

0 Yes

1 No

What does “select count(*) from tab” result? ..

Answer / shanmukha srinivas

select count(*) from tab --it's gives total no of tables only ....not gives
sequence,cluster,views....etc
ok understand.

Is This Answer Correct ?

0 Yes

1 No

What does “select count(*) from tab” result? ..

Answer / brajesh kr.

select count(1) from table. will return values without null
values. count(*) will return values aceept null also.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer