Using a Cursor to Retrieve Data From One Table and Insert Into Another table

[seema chhetri]

Using a Cursor to Retrieve Data From One Table and Insert Into Another

i tried the below code but it couldnt helped...

      p_delta_sequence NUMBER  NOT NULL:= 1233;
        p_delta_date DATE  NOT NULL:= SYSDATE;
  CURSOR c1 IS
        select delta1.delta_sequence, delta1.delta_date
           from cssng_psap_tcs_delta delta1;
BEGIN
        --P_DELTA_SEQUENCE := 2254;
        --P_DELTA_DATE := SYSDATE;
      FOR c1_rec IN c1
      LOOP
                p_delta_sequence :=c1_rec.delta_sequence;
                p_delta_date :=c1_rec.delta_date;
                
                DBMS_OUTPUT.PUT_LINE('Delta SEQUENCE' ||' '||p_delta_sequence);
                DBMS_OUTPUT.PUT_LINE('Delta DATE' ||' '||p_delta_date);

            Insert into cssng_psap_intrado_delta(delta_sequence, delta_date)
                        values(c1_rec.delta_sequence, c1_rec.delta_date);
           COMMIT;
      END LOOP;
      COMMIT;
      END;

thanks

[fred rosenberger]

Nope. We don't hand out answers here. Folk will help YOU write it, but you need to Show Some Effort yourself.

Or, you can always make a post in "Jobs offered" and see if anyone will code it for a fee.

[chris webster]

As Fred says, you should ShowSomeEffort.

However, here is a tip: Use "INSERT...SELECT" to perform the SELECT and the INSERT in a single statement e.g.

INSERT INTO cssng_psap_intrado_delta(delta_sequence, delta_date) SELECT col1, col2 FROM some_other_table WHERE etc....

You should be able to figure it out from here.

[Edited my reply after I spotted the fairly obvious fact that you are using Oracle PL/SQL - doh!]