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 |
What is the maximum number of statements that can be specified in a trigger statement?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what are the important table names in purchasing?
In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?
What is instead of trigger in where we will use?
After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?
Can u define DFF with in the DFF,How?
how will you refer a report column (data column,formula,summery,placeholderr)?
in ap_terms table what data will be stored
what is meant by boilerplates?
Oracle E-Business suite?
How can we import the data into a database using sql * loader?