DesignO

Burghardt GoLive - Delete Catalog

Oct 20th, 2014
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.50 KB | None | 0 0
  1. DELETE FROM rl_makers
  2. WHERE created_by = 34359738413;
  3.  
  4. DELETE FROM RL_CATEGORY_HIERARCHY
  5. WHERE
  6.   CREATED_BY = 34359738413
  7. AND
  8.   web_category = 1;    
  9.  
  10. DELETE FROM FRAMES
  11. WHERE
  12.   created_by = 34359738413;
  13.  
  14. DELETE FROM SUNGLASSES
  15. WHERE
  16.   created_by = 34359738413;
  17.  
  18. DELETE FROM ACCESSORIES
  19. WHERE
  20.   CREATED_BY = 34359738413;
  21.  
  22.      
  23. DELETE FROM ITEMS
  24. WHERE
  25.   created_by = 34359738413
  26. AND
  27.   Practice_ID = 1;  
  28.    
  29. DELETE item_images
  30. WHERE CREATED_BY = 34359738413
  31. AND
  32. Practice_ID = 1;
Add Comment
Please, Sign In to add comment