What does “select count(*) from tab” result?
Answers were Sorted based on User's Feedback
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 |
Answer / ashwin
No of tables and views in schema...........i've tasted
it........
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / deepshikha
it will result the count of TABLE,CLUSTER,VIEW,SYNONYM
in given schema
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / nisha
This results the total count of tables,views,synonyms
present in a schema.
Is This Answer Correct ? | 3 Yes | 4 No |
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 |
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 |
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 |
What is the difference between truncate and drop statements?
What are procedures used for?
What is procedure and function?
What is graph sql?
How do I truncate a word?
What is normalization? dec 2009
Which is better join or inner query?
What is a transaction?
What is RAC in oracle?
Explain constraints in sql?
what is the difference difference between procedure and packages
2 Answers 3i Infotech, Oracle,
Is sql an operating system?