Hi,
We're using Oracle 11.2. I am looping through a cursor and using a MERGE statement to load my values into a table.
How do I display the values for a row of my cursor in the USING ( ) clause of the Merge statement?
.
.
.
CURSOR CPC_LOAD_CUR
IS
SELECT t.*
FROM EDW.TABLE_IM_USING t
where FILLED_EARLIEST_DATE >= add_months(sysdate, - 24);
BEGIN
FOR i IN CPC_LOAD_CUR
LOOP
BEGIN
MERGE INTO RDW.MART_MEM_MEDS b
USING ( < Cursor row goes here but how do I display it?> ) e
ON (b.NDC = e.NDC and e.FILLED_EARLIEST_DATE >= add_months(sysdate, - 24))
.
.
.
Do I use a Varray?