it will result the count of TABLE,CLUSTER,VIEW,SYNONYM in given schema

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

Question Posted / deepshikha

Answer Posted / deepshikha

it will result the count of TABLE,CLUSTER,VIEW,SYNONYM
in given schema

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain what is a view?

1044

Why do we use function in pl sql?

1045

How do you write an index?

949

what is unique key constraint? : Sql dba

1022

What is oracle pl sql developer?

964

What is normalisation and its types?

989

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1166

What do you mean by “trigger” in sql?

1055

How can I speed up sql query?

938

how would you enter characters as hex numbers? : Sql dba

968

Which certification is best for sql?

974

Does oracle roll back the transaction on an error?

1000

What do you mean by field in sql?

1069

What are the types of join and explain each?

1021

What is interval partition?

1042