ORACLE PRINT

DECLARE cursor C_YON_DEG is SELECT Y.ROWID ROW_ID,RF_SUBE_KOD_YEDEK FROM YONLENDIRME_DEGERLENDIRME Y WHERE FL_DURUM = 1;

P_SUBE VARCHAR2(50);

BEGIN

FOR CR IN C_YON_DEG LOOP

SELECT CD_SUBE_KOD INTO P_SUBE FROM SUBE WHERE FL_DURUM = 1 AND CH_SUBE_AD = CR.RF_SUBE_KOD_YEDEK;

dbms_output.put_line (P_SUBE);
dbms_output.put_line (CR.ROW_ID);

UPDATE YONLENDIRME_DEGERLENDIRME Y
SET Y.RF_SUBE_KOD = P_SUBE
WHERE Y.ROWID = CR.ROW_ID;

END LOOP;

END;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: