title: How to generate DELETE statements in PL/SQL, based on the tables FK relations?
body: <p>Is it possible via script/tool to generate authomatically many delete statements based on the tables fk relations, using Oracle PL/SQL?</p>
  
  <p>In example: I have the table: CHICKEN (CHICKEN_CODE NUMBER) and there are 30 tables with fk references to its CHICKEN_CODE that I need to delete; there are also other 150 tables foreign-key-linked to that 30 tables that I need to delete first.</p>
  
  <p>Is there some tool/script PL/SQL that I can run in order to generate all the necessary delete statements based on the FK relations for me?</p>
  
  <p>(by the way, I know about cascade delete on the relations, but please pay attention: I CAN'T USE IT IN MY PRODUCTION DATABASE, because it's dangerous!)</p>
  
  <p>I'm using Oracle DataBase 10G R2.</p>
  
  <p>Please pay attention to this:</p>
  
  <p><a href="https://stackoverflow.com/questions/485581/generate-delete-statement-from-foreign-key-relationships-in-sql-2008/2677145#2677145">Generate Delete Statement From Foreign Key Relationships in SQL 2008?</a></p>
  
  <p>Another user has just written it in SQL SERVER 2008, anyone is able to convert to Oracle 10G PL/SQL?
  I am not able to... :-(</p>
  
  <p>Please assume that V_CHICKEN and V_NATION are the criteria to select the CHICKEN to delete from the root table: the condition is: "where COD_CHICKEN = V_CHICKEN AND COD_NATION = V_NATION" on the root table.</p>