Jump to content
Sign in to follow this  
unexistance

Oracle Cursor + Loop

Recommended Posts

Dear Otai Oracle,

Macam mana nak masukkan data dari cursor ke loop?

contoh:

DECLARE
CURSOR C1 IS 
    SELECT aa, bb ,cc, dd, .. --(23 column)
    FROM table1
    WHERE aa='1330'
    AND bb='31/dec/2007';
BEGIN 
FOR R_C1 IN C1
    LOOP
    INSERT INTO table2 VALUES (R_C1)
    EXIT WHEN C1%NOTFOUND;
    END LOOP;
COMMIT;
END;

sebab bila run statement ni, dapat error invalid syntax

dekat line INSERT.

1. ada error dekat syntax ke?

tambah semicolon pun keluar error,

buang kurungan R_C1 pun error jugak

2. ada cara yang lagi mudah tak, selain tulis sebiji2 23 column name menggantikan R_C1 tu?

(buat macam tu very error prone)

Thanks in advance..

Share this post


Link to post
Share on other sites

Dear Otai Oracle,

Macam mana nak masukkan data dari cursor ke loop?

contoh:

DECLARE
CURSOR C1 IS 
    SELECT aa, bb ,cc, dd, .. --(23 column)
    FROM table1
    WHERE aa='1330'
    AND bb='31/dec/2007';
BEGIN 
FOR R_C1 IN C1
    LOOP
    INSERT INTO table2 VALUES (R_C1)
    EXIT WHEN C1%NOTFOUND;
    END LOOP;
COMMIT;
END;

sebab bila run statement ni, dapat error invalid syntax

dekat line INSERT.

1. ada error dekat syntax ke?

tambah semicolon pun keluar error,

buang kurungan R_C1 pun error jugak

2. ada cara yang lagi mudah tak, selain tulis sebiji2 23 column name menggantikan R_C1 tu?

(buat macam tu very error prone)

Thanks in advance..

bang btol ke insert statemnnt tu?

INSERT INTO table2 (namafieldmana?) VALUES (R_C1)

EXIT WHEN C1%NOTFOUND;

Share this post


Link to post
Share on other sites

kalau Oracle, tak perlu pun takpe.. asalkan bilangan column sama..

Unless you're telling me, inside the loop, you have to use such statement, no shortcut, is it?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...