Evra70

a

Dec 8th, 2021
896
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN;
  2.  
  3.  
  4. create table in_log_product_balance_stock_20211208 as (
  5. SELECT * FROM in_log_product_balance_stock
  6. WHERE doc_type_id =  311   
  7. AND ref_id = 95
  8. AND doc_no = 'DO-2111-000001'
  9. AND doc_date ='20211110'
  10. );
  11.  
  12.  
  13. DELETE FROM in_log_product_balance_stock
  14. WHERE doc_type_id =  311   
  15. AND ref_id = 95
  16. AND doc_no = 'DO-2111-000001'
  17. AND doc_date ='20211110'
  18. --rollback
  19. --commit;
RAW Paste Data