Skip to content

Instantly share code, notes, and snippets.

@amcintyre99
Last active December 23, 2015 07:49
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save amcintyre99/3702bf78aabc684027e5 to your computer and use it in GitHub Desktop.
begin
for mavg as
with
avgs (avgx) as
(values 1, 10, 100, 1000)
select avgx
from avgs
do
insert into replxa (....)
with
awin as
(select ......
...........
........... = mavg.avgx
...........
);
end for;
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment