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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

In sequence i want to 11 and 15th values how we will write?

2040


How can you achieve loose coupling in soa framework?

1186


what is the difference between request group and request security in oracle apps?

5822


what is the differences between internal requisition and internal sales order?

2615


Explain oracle apps architecture.

1205


Can we create tables in apps schema?

1097


How to create a purchase order without a requisition?

1141


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2589


what is global tempory table?

7152


can we use look up type instead of a pofile option?or valueset?is it possible how?

2179


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2058


What is a flexfield? List out its types.

1123


What are the benefits of using soa architecture?

1195


Tell me how to find the custom directory in front end?

1072


can we get profile values in report without using user exists is it possible how?

2838