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

Answer Posted / sunil

Tab is system view which will provide you the list of
table,view,cluster,synonym in the current schema .

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster truncate or drop?

560


How does postgresql compare to mysql?

576


what are all the different types of indexes? : Sql dba

530


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

671


How exception handling is done in advance pl/sql?

499






What is coalesce sql?

516


How to select random rows from a table?

522


What is the difference between left and left outer join?

517


Is oracle and sql same?

575


Which are sql * plus commands?

539


What is a temporal data type?

597


How is a PL/SQL code compiled?

670


Explain foreign key in sql?

621


What are the operators used in select statements?

578


Explain the methods used to protect source code of pl/sql.

544