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.

What is Trace File ?

4 Answers   Thermotech,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

What are the different approaches used by Optimizer in choosing an execution plan ?

2 Answers  

---

Can we protect our pl/sql source code?

0 Answers  

---

what is grid in Oracle 10g...

1 Answers  

---

---

Can u make a synonym for deptno=10 only from emp table.

1 Answers   TCS,

---

sql command 2 know current database

4 Answers  

---

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?

0 Answers   Mastek,

---

How can we create the complete backup of data in the oracle.

0 Answers   IPEC, Satyam, SunTec,

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

what is primary key and foreign key when and where have to use

5 Answers  

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

0 Answers   MCN Solutions,

---