how i can create temporary table?



how i can create temporary table?..

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

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More Oracle Apps Technical Interview Questions

what are the receipt types in Po?

2 Answers   Evosys, UST,


Do you know where we can check the status of po?

0 Answers  


how to debug the report?

2 Answers   IBM, Qualcomm, Sierra Atlantica,


What is the package?

2 Answers  


What do you understand by concurrent programs?

0 Answers  






We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


In oracle application how do you debug or trace errors?

0 Answers  


tell me the scenarios of between pages in reports

5 Answers  


what is mutating table and mutating error and how to solve that?

3 Answers  


what is the database size you used?

1 Answers   FIS,


what is the difference between procedure and function

3 Answers   Wipro,


types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)