Skip to content

Instantly share code, notes, and snippets.

@aconfee
Created October 24, 2016 21:11
Show Gist options
  • Save aconfee/173db89cfb6c86098b6b64e7675ad256 to your computer and use it in GitHub Desktop.
Save aconfee/173db89cfb6c86098b6b64e7675ad256 to your computer and use it in GitHub Desktop.
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