What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
No Answer is Posted For this Question
Be the First to Post Answer
What is a package in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
Why does for update in oracle 8 cause an ora-01002 error?
Explain mutating triggers.
Explain the use of tables option in exp command.
what are the diffeenes between oracle 9i,oracle 10g
What is autonomous transaction?
how can we write trigger in trigger???????? can we write one trigger on two table???
What is blob datatype?
How to execute a stored program unit?
How to define an explicit cursor in oracle?
what is a Nested Loop join?