what is analyze command ? what kind of statistics does it
generate?
Answers were Sorted based on User's Feedback
Answer / mr. chandra
analyze command is used to check the statics of the query
and performance.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / brahma prakash
It Analyze the cost of the query with shortest excution path
Is This Answer Correct ? | 0 Yes | 0 No |
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
how to hide the stored procedure inside a package
How many types of segments in Oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
if you update view? where we store the data?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How many categories of data types?
How to work with data objects interactively?
Explain the use of indexes option in exp command.
What are a query and state the different types of queries and their uses?
What are the restrictions in a oracle read only transaction?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.