Oracle Database Discussions

I would like to know how to Delete Data from Tables using Delete command.

The Requirement is to Delete Specific Data History. Using some Parameters maybe.

What is the sequence to delete tables from the database?

I detected 4 groups of tables:

1. Setup/ Standard Tables.
2. Catalog Tables.
3. Custom Tables.
4. Log´s Tables.
5. The tables are Custom, is a Custom Process, but There are recommendations/ suggestions about it?
6. How to know The Parent - Child Relationship? The Child Table to start to Delete Details/Extra Tables?

Which is the order to Delete Data from Tables?

What is the recommendation/ suggestions about it?

My Idea is to:

1. Create a Package into the Dev Database.
2. Create a Package Body into the Dev Database.
3. How to start to Delete Tables?
4. How to delete without errors Prent child, constraints, triggers, etc