What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Answer / guest
This value causes the optimizer to the cost-based approach
for all SQL statements in the session regardless of the
presence of
statistics and to optimize with a goal of best throughput.
Is This Answer Correct ? | 0 Yes | 0 No |
How to find no of saturdays in a month using single sql ?
What is recovery manager(rman) backup in Oracle?
How to drop an existing table in oracle?
How can you merge two tables in oracle?
How to update values on multiple rows in oracle?
what is candidate key & super key
How to select an oracle system id (sid)?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
What WHERE CURRENT OF clause does in a cursor?
What is coalesce function?
Explain the blob datatype?
How to concatenate two text values in oracle?