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

Explain how can you save or place your msg in a table?

769


what is oltp (online transaction processing)? : Sql dba

716


Can we use join in subquery?

772


How can you fetch common records from two tables?

772


what is heap table? : Sql dba

792






is it possible to pass an object or table to a procedure as an argument?

812


Is sql better than access?

708


What is sql not null constraint?

771


What is pl sql collection?

688


What is a record in pl/sql?

756


What is union, minus and interact commands?

931


How do I truncate a sql log file?

731


what are the types of join and explain each? : Sql dba

758


How many clustered indexes can you have?

726


where are cookies actually stored on the hard disk? : Sql dba

782