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

What is responsibility and how u attach

5 Answers   Accenture,


I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,


mention the interface tables for item open interface and open transaction interface and also their respective production tables.

1 Answers   Scan Steel,


Are you familiar with internet architecture of oracle apps 11i?

0 Answers  


why do we go for oracle apps technical other than sap and other packages?

2 Answers  


what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,


What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,


What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,


maximum how many parameters we can pass through pl/sql stored procedure to oracle apps?how many mandatory parameters we can pass through pl/sql program to oracle apps11i?

6 Answers   LG Soft,


What is a flexfield? List out its types.

0 Answers  


Difference between Bind and Lexical parameters?

3 Answers  


What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,


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)