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 |
How to know the number of invoices generated for one PO from front end (navigation)?
in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
tell my any difficult situtation you solved in your experience in your company?
what is difference between po_headers_all and po_headers
i have 100 pages output. i want to print 10 records per page in Template?
what are version control tools used in oracle apps?
tell me the scenarios of the independent in reports
what is pick selection list generation report.
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
can we use commit in trigger? If yes how?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
what are the important table names in purchasing?