What is the effect of setting the value 'FIRST_ROWS' for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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 |
Explain oracle data types with examples?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Is there an oracle sql query that aggregates multiple rows into one row?
How to best split csv strings in oracle 9i?
What is the difference between alert log file and trace file ?
What is meant by raw datatype?
Explain coalesce function?
Draw E-R diagram for many to many relationship ?
11. Display the client number and name and the client number and name of the person who referred that client.
Explain the difference between sap and oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?