pl/sql developer 使用

jack9981

我建了个sql window 窗口，要执行下面语句，老报错？
cursor c is
select * from branch_list;

i int := 0;

for rec in c
loop
    i++;
    insert into xbranch values( i, 0, rec.nodeid, rec.nodename, null );
end loop

commit;

难道要建存储过程才能运行？

jack9981

insert into xbranch select sequence,0,nodeid,nodename,null from branch_list;
-----------
ora-00904 "sequence", invalid identifier