IN t_id.FIRST .. t_id.LAST
insert into B(id) values(t_id(id));
commit ;
END;
/
HTH. Milen
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 15. August 2003 13:39
An: Multiple recipients of list ORACLE-L
Betreff: Question ab
L PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED]Subject: Question about cursors
Hallo,
I would like to get a goood example on how to do this in a pl/sql block, maybe this
is too simple but I cant get it work.
I would like to do a select from table A, like this
select id from A
where id > 10
This sql statement gives me about 10 rows. I want those rows(the id) to be inse