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 |
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Display the number value in Words?
What is java oracle used for?
what is the difference between substr and instr function in oracle?
what are bitmap indexes? How does they work?
What is autonomous transaction?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
Who developed oracle & when?
How to get the Installed Oracle Version Information ?
How to drop an existing view in oracle?
Explain what are the advantages of views?