it will display the total number of tables in the schema.

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

Question Posted / shivashanker

Answer Posted / shivashanker

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Define select, insert, create, delete, update, drop keywords

1053

What is sqlite format?

1205

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1144

Why truncate is used in sql?

1011

List the ways to get the count of records in a table?

902

What is varchar sql?

1152

What are sql built in functions?

944

Explain raise_application_error.

1106

What is raw datatype in sql?

1050

What is a heap in sql?

1077

What is difference between rank () row_number () and dense_rank () in sql?

1109

What program will open a mdb file?

970

What is the default isolation level in sql server? : Transact sql

1036

What is a memo field?

972

What's the difference between inner join and left join?

1005