What does “select count(*) from tab” result?
Answer Posted / 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 |
Post New Answer View All Answers
What is scalar and vector?
What is the difference between a primary key and a unique key?
What are different methods to trace the pl/sql code?
Does sql full backup truncate logs?
What is use of trigger?
explain the advantages and disadvantages of stored procedure? : Sql dba
What is compiled query?
What packages(if any) has oracle provided for use by developers?
What are few of the schema objects that are created using PL/SQL?
What is latest version of sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is nvl?
What can you do with pl sql?
What is the difference between clustered and non-clustered index in sql?
What is crud sql?