What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
Answer / guest
This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics
| Is This Answer Correct ? | 0 Yes | 0 No |
What is instant client oracle?
8. Display the client name and order date for all orders using the natural join keywords.
Difference between varchar and varchar2 data types?
i want department wise maxmum salary and empolyee name
Will you be able to store pictures in the database?
Explain drop constraint oracle?
How to create an oracle database?
Why is oracle database so popular?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What is the dynamic sql in oracle?
What is the max number of columns in an oracle table?
What is the data pump import utility?