title: Deleting a row from all the tables in a schema
body: <p>I have a schema, named BILL, and in this schema all the tables have a column named ID. I need a way to delete the row from all the tables, where ID = 'test'. There are a lot of schemas, so it is important that i only delete them from BILL. There are tables that don't contain a test row too if it matters. This is an oracle database.</p>
  
  <p>I couldn't figure out how to do this with sql. Maybe pl/sql? Any thoughts?</p>