Answer / guest

to enable trace:

alter session set sql_trace=TRUE

to disable trace:

alter session set sql_trace=FALSE

Answer / anji

to enable the trace in anther session

EXECUTE dbms_support.start_trace_in_session (sid,serial#);

To stop the trace in anther session

EXECUTE dbms_support.start_trace_in_session (sid,serial#);

Explain materialized views and how they are used.

2 Answers  

---

where the dff data will be stored

0 Answers   Infosys,

---

What is the use of lockboxes? : oracle accounts receivable

0 Answers  

---

default triggers available for reports

0 Answers  

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

0 Answers  

---

---

what is the difference between oracle 81,91,11i

2 Answers   i2, Oracle,

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

0 Answers   L&T,

---

please explain about oracle

1 Answers  

---