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

Answer Posted / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Is This Answer Correct ?    61 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 19 null in sql?

536


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

522


What is composite primary key in sql?

524


How do I quit sql?

502


How do you respond to dementia behavior?

533






How do you define a foreign key?

539


What is difference between primary and secondary key?

519


What is sql select statement?

508


define data blocks ? : Sql dba

552


what is the different between now() and current_date()? : Sql dba

526


What are the two different parts of the pl/sql packages?

568


what are the types of subquery? : Sql dba

592


How to load data with sql*loader?

552


What is compound trigger?

561


What are the different types of constraints?

566