What does “select count(1) from tab” result?
- 10 Answers
- 19472 Views
- IBM, I also Faced
- E-Mail Answers
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
What is the difference between a database and a relational database?
What is your daily office routine?
what is online transaction processing (oltp)? : Sql dba
Can we use ddl commands in pl sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Do we need to rebuild index after truncate?
What is the location of pre_defined_functions.
How does a trigger work?
If a cursor is open, how can we find in a pl/sql block?
What are different types of indexes?
How many types of literals are available in pl sql?
How do I view a procedure in sql?
Mention what does the hierarchical profiler does?
What is the maximum number of columns in sql table?
Name the operator which is used in the query for pattern matching?
