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 |
In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.
10 Answers HCL, TCS,
What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1
what is the purpose of standard cost update?
what is the difference between procedure and function
is it possible to run the interface without using oracle apps?
Hi Experts How to Create a purchase order without a requisition ?
6 Answers Amdocs, KPMG, Oracle,
how can we get odd numbered pages in output of a report
When you run he report you have to get only that particular organization po numbers or item number how can do it?
Tell me some thing about SQL-LOADER.
Can we customize a form with out template.fmb
What is procedure?
in procedure how to return a value