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 responsibility and how u attach
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.
Are you familiar with internet architecture of oracle apps 11i?
why do we go for oracle apps technical other than sap and other packages?
what are the prerequisite set ups for inter organization transaction?
What are Mandatory triggers to write in the block, which is created on view?
What is the maximum number of statements that can be specified in a trigger statement?
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?
What is a flexfield? List out its types.
Difference between Bind and Lexical parameters?
What is MO operating units. Why it need to to set this and where .