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
What is 19 null in sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is composite primary key in sql?
How do I quit sql?
How do you respond to dementia behavior?
How do you define a foreign key?
What is difference between primary and secondary key?
What is sql select statement?
define data blocks ? : Sql dba
what is the different between now() and current_date()? : Sql dba
What are the two different parts of the pl/sql packages?
what are the types of subquery? : Sql dba
How to load data with sql*loader?
What is compound trigger?
What are the different types of constraints?