how will u find statistics of a database objects?
Answer Posted / senthil vinayagam
Using analyze command
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to get list of all tables from a database?
What will you get by the cursor attribute sql%rowcount?
What is the size of partition table?
what are the differences between char and varchar? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is record variable?
Is left join inner or outer?
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.
What are different clauses used in sql?
What is substitution variable in pl sql?
How do I copy a table in sql?
What is secondary key?
What is cascade in sql?
How many commands are there in sql?
Can you load data into multiple tables at once? : aql loader