Select Code to Download

create or replace procedure myProc
as
begin
  select * from whatever;
end;

delete from mytable
  where my_id='12345'
...
insert into anothertable
values ('123456','somedata');
/