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...


what is global tempory table?



what is global tempory table?..

Answer / jijo

Global temporary tables are temporary table for perticular session.
Global temporary tables are two types,
1.Transaction wise temporary table
2.Session wise temporary tables.
In transaction wise temporary tables we will use on commit delete rows keyword, which delete the data whenever we do commit.
In session wise temporary table we will use on commit preserve rows keyword, which preserve the data till the end of that session.

Is This Answer Correct ?    24 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

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

1 Answers   Scan Steel,


what are the different types of triggers in reports

2 Answers   Oracle,


why we can use synonym?

6 Answers  


While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,


in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,


what is the standard program for blanket po to process data from interface table to bace table

3 Answers   Zensar,


how do you describe O2C along with tables

0 Answers   TCS,


How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,


What is SET-OF-BOOKS?

3 Answers  


What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,


Give a brief overview on OrderManagement.

1 Answers   Zensar,


in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

1 Answers   Oracle,


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)