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

Answer Posted / nisha

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

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the primary key an index?

595


Explain autonomous transaction.

632


What is scalar data type in pl sql?

549


Can we insert in sql function?

537


Can triggers stop a dml statement from executing on a table?

615






What is the difference between nvl function, ifnull function, and isnull function?

587


What is user in sql?

575


What are inner and outer joins examples of both?

494


Do we need to create index on primary key?

463


what is dbms? : Sql dba

541


Explain mutating table error.

645


How do I enable sql encryption?

518


What are tables and fields in the database?

552


What is difference between hql and sql?

503


How can you tell the difference between an index and a view?

489