Answer / m.n

CREATE GLOBAL TEMPORARY TABLE TEMP_TRAN
(
COL1 NUMBER(9),
COL2 VARCHAR(30),
COL3 DATE,
CONSTRAINT PK_TEMP_TRAN PRIMARY KEY(COL1)
) ON COMMIT DELETE ROWS

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

what is unit of measure classes? give atleast two examples. name the underlying table.

1 Answers   Scan Steel,

---

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

---

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

---

Tell me where we find the status of order information?

0 Answers  

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

what are the receipt types in Po?

2 Answers   Evosys, UST,

---

what are the types of interfacing?

3 Answers   TCS,

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

what is meant by Table space?

2 Answers  

---

In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,

---