Not understanding cursor

Question

The problem i'm dealing with is follow :

I have a table students with name and surname. I create a new table Students2, and i want to fill this table with names and surnames from the first table with cursor.

I make the declare of the cursor, the select part, but in the LOOP PART, i don't understand how you fetch the values. For example, if I do:

  FETCH name_surname INTO Students2.name,Students2.surname

it doesn't work, and I don't know how to fix it.

In name_surname I mention, I Selected the name and surname from the first table.

Possible duplicate of [INSERT and UPDATE a record using cursors in oracle](http://stackoverflow.com/questions/11921889/insert-and-update-a-record-using-cursors-in-oracle) — XING, Mar 04 '17 at 17:28
Why must you do this using a cursor? Plain SQL would be simpler. Also, define "doesn't work". — William Robertson, Mar 04 '17 at 20:46

score 0 · Answer 1 · edited Mar 04 '17 at 19:01

0

"Declare cursor c1 is select * from student2;
Begin
For i in c1 loop
Dbms_output.put_line(i.fname||','||i.lanme);
End loop;
End;"

edited Mar 04 '17 at 19:01

sa77

3,563
3
24
37

answered Mar 04 '17 at 18:10

Prakashh Badeakar

1
2

Not understanding cursor

1 Answers1