What spfile/init.ora file parameter exists to force the CBO
to make the execution path of a given statement use an
index, even if the index scan may appear to be calculated as
more costly?
No Answer is Posted For this Question
Be the First to Post Answer
What is an Index ?
Why does for update in oracle 8 cause an ora-01002 error?
how can we write trigger in trigger???????? can we write one trigger on two table???
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 private procedure oracle?
Explain the use of owner option in exp command.
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
Can we create trigger on materialized view in 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?
How would you begin to troubleshoot an ORA-3113 error?
Explain the relationship among Database, Tablespace and Data file?
What are the tools for Oracle ?