Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How to know the number of invoices generated for one PO from front end (navigation)?

1 Answers   Oracle,


in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,


tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,


what is difference between po_headers_all and po_headers

2 Answers   NTT Data,


i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,


what are version control tools used in oracle apps?

1 Answers   Cap Gemini, Sony,


tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,


what is pick selection list generation report.

3 Answers  


Is it possible calling from one report to another? if possible means tell me ?

3 Answers   Intelligroup, Satyam,


can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,


Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,


what are the important table names in purchasing?

3 Answers   TCS,


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)