declare
no empmaster.no%type;
name empmaster.name%type;
cursor abc is select No,Name from empmaster where
city='Bombay';
begin
open abc;
loop fetch abc into no,name;
exit when abc%notfound;
insert into citylist values(No,Name);
end loop;
close abc;
end;
No comments:
Post a Comment