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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What plvcmt and plvrb does in pl/sql?

881


What are the operators used in select statements?

578


How do you explain an index number?

535


How to use boolean type in select statement?

583


How do I sort a table in sql?

597






How to select unique records from a table?

571


Why commit is not used in triggers?

583


Can we use view in stored procedure?

508


What are the ddl commands?

537


What are dml commands?

529


What are the topics in pl sql?

521


Are there any features that are decommissioned in 11g that are not present in 11g?

1593


What are aggregate functions in sql?

629


What are the two parts of design view?

581


What is crud stand for?

570