display all the table which are currently in the schema.

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

Question Posted / kamal kishore kashyap

Answer Posted / kamal kishore kashyap

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Is ms sql traffic encrypted?

908

Why function is used in sql?

923

Does truncate need commit?

921

How to select all records from the table?

1115

Can sql developer connect to db2?

1011

What are all different types of collation sensitivity?

1014

What are different types of indexes?

995

How do you optimize a stored procedure query?

983

Which query operators in sql is used for pattern matching?

940

What is file based approach?

924

What is the use of desc in sql?

955

Explain what is an index?

1033

what is the difference between truncate and drop statements? : Sql dba

1093

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1025

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1026