Part of Slepp's Projects — Pastebin — TURL — Imagebin — Filebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate
Sign In | Create Account

Advertising

advertising

related pastes to tag 'ubs'

1517636 - Oracle_SP: oracle work sp ubs
  1. CREATE OR REPLACE procedure SKEMAIN.clearDownUserX(
  2.   userName users.LOGINNAME%type)
  3. AS
  4. begin
  5. -- all active cancel requested or requested orders set to cancelled and inactive.
  6.   UPDATE orders SET
  7.       active = 0,
  8.       stateId = 7
  9.  
738705 - SKE Queries: oracle ubs ske
  1. SELECT count(*) FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=21053);
  2.  
  3. DELETE FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=21053);
  4.  
  5. DELETE FROM orders WHERE traderuserid=21053;
738611 - SKE Queries: oracle ubs ske
  1. SELECT count(*) FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=19214);
  2.  
  3. DELETE FROM orderhistory WHERE orderid IN (SELECT id FROM orders WHERE traderuserid=19214);
  4.  
  5. DELETE FROM orders WHERE traderuserid=19214;
738610 - Oracle_SP: oracle work sp ubs
  1. CREATE OR REPLACE procedure SKEMAIN.clearDownUserX(
  2.   userName users.LOGINNAME%type)
  3. AS
  4. begin
  5. -- all active cancel requested or requested orders set to cancelled and inactive.
  6.   UPDATE orders SET
  7.       active = 0,
  8.       stateId = 7
  9.  
worth-right
 fantasy-obligation