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 is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,


Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

0 Answers  


what are the important table names in purchasing?

3 Answers   TCS,


In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  


What is instead of trigger in where we will use?

0 Answers  






After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,


Can u define DFF with in the DFF,How?

1 Answers   Satyam,


how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  


in ap_terms table what data will be stored

1 Answers  


what is meant by boilerplates?

1 Answers  


Oracle E-Business suite?

2 Answers  


How can we import the data into a database using sql * loader?

0 Answers  


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)