Skip to content

Instantly share code, notes, and snippets.

@aconfee

aconfee/gist:173db89cfb6c86098b6b64e7675ad256

Created October 24, 2016 21:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aconfee/173db89cfb6c86098b6b64e7675ad256 to your computer and use it in GitHub Desktop.
Save aconfee/173db89cfb6c86098b6b64e7675ad256 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
begin
for i in (select * from vehiclecache.auctionvehicles where auctiondate > sysdate and ((make = 'Chevrolet' and model = 'Cruze') or make = 'Tesla'))
loop
vehiclecache.avindexqueueservice.AddToQueue(i.id, 'U');
end loop;
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment