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


Please Help Members By Posting Answers For Below Questions

What is rank () in sql?

531


What is sql constant?

507


What is raid? How does it help storage of databases?

599


What is fmtonly in sql?

527


How do you know if a relationship is 2nf?

518






What are the syntax and use of the coalesce function?

551


Mention what are the benefits of pl/sql packages?

534


what is msql? : Sql dba

562


Can ddl statements be used in pl/sql?

594


Can we perform dml on view?

552


Why use triggers in sql?

500


What is sql in java?

543


How do I view a sql trace file?

564


What is the difference between jpql and sql?

552


What is java sql driver?

548