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

Answer Posted / shivashanker

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

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to check if a column is nullable before setting to nullable?

766


What is sql*loader and what is it used for? : aql loader

802


Show code of a cursor for loop.

768


What are % type and % rowtype?

772


Explain exception handling in pl/sql?

721






Is sql a oracle?

691


What is cursor in pl sql with examples?

670


Can we create a trigger on view?

664


What is scope and visibility in PL/SQL?

767


Which is faster truncate or drop?

770


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

755


how to select unique records from a table? : Sql dba

822


What are sql ddl commands?

734


what happens if null values are involved in expressions? : Sql dba

734


How do I quit sql?

682