Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
- 1 Answers
- 4391 Views
- I also Faced
- E-Mail Answers
Answer / guest
This value causes the optimizer to use 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 response time.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a tns file?
17. Display the order number and average item cost for each order.
What is procedure overloading in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
how to find count rows in table without count function?
how to use sequence and what use of sequence cache
Explain about your project and its relation to the current job position you are applying to?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is data block in Oracle?
What is an Extent ?
How to delete multiple rows from a table in oracle?
How to retrieve 5th highest sal from emp table?
Oracle General 
