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

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,


What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,


what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,


what is the difference between procedure and function

4 Answers  


is it possible to run the interface without using oracle apps?

2 Answers   Accenture,


Hi Experts How to Create a purchase order without a requisition ?

6 Answers   Amdocs, KPMG, Oracle,


how can we get odd numbered pages in output of a report

2 Answers   Infosys,


When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,


Tell me some thing about SQL-LOADER.

2 Answers   IBM,


Can we customize a form with out template.fmb

5 Answers   Zensar,


What is procedure?

3 Answers   IBM,


in procedure how to return a value

4 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)