What is the recommended interval at which to run statspack
snapshots, and why?
No Answer is Posted For this Question
Be the First to Post Answer
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
Explain the use of Merge statement in oracle 11g
What are a query and state the different types of queries and their uses?
What are the advantages of oracle?
What is a table in oracle?
what is IDE,DMV in sql server?
Please explain compound trigger in oracle?
How to update values on multiple rows in oracle?
What is the best way to do multi-row insert in oracle?
What is the parameter mode that can be passed to a procedure?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?