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
Which is faster truncate or drop?
How does postgresql compare to mysql?
what are all the different types of indexes? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How exception handling is done in advance pl/sql?
What is coalesce sql?
How to select random rows from a table?
What is the difference between left and left outer join?
Is oracle and sql same?
Which are sql * plus commands?
What is a temporal data type?
How is a PL/SQL code compiled?
Explain foreign key in sql?
What are the operators used in select statements?
Explain the methods used to protect source code of pl/sql.