select count(1) from tab will give the total number of tables,views and s

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

Question Posted / gourvendra singh

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

Please Help Members By Posting Answers For Below Questions

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1104

What is sqlca in powerbuilder?

1067

Can we connect to postgresql using sql developer?

1048

How to run sql statements through the web interface?

1093

How do I debug a stored procedure?

1171

what is a composite key ? : Sql dba

1101

What is the maximum number of columns in sql table?

1228

Does sql*plus also have a pl/sql engine?

1131

Write a query to find the names of users that begin with "um" in sql?

1045

Can a primary key be a foreign key?

1079

Can we insert data into materialized view?

993

What is a string data type in sql?

1100

what is the difference between where clause and having clause? : Sql dba

1045

What is mutating trigger?

1073

What packages(if any) has oracle provided for use by developers?

5883