Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. -- This is oracle-specific.
  2. -- If using * instead of img.*, if there is a FK relationship, deletion will occur in both tables!
  3.  
  4. DELETE (SELECT
  5. img.*
  6. FROM
  7. storeord.cpc_space spc
  8. INNER JOIN storeord.cpc_image img
  9. ON spc.FILE_ID = img.FILE_ID
  10. WHERE
  11. spc.space_uuid = ?
  12. AND img.wall_name = ?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement