Hello
I am trying to be a oracle apex and pl/sql developer and I have a question about best practices.
Let's imagine I have a apex application to manage customers. Then I have a few tables, CUSTOMERS, ADDRESSES,COURSES,CARS,PERMITS(Vacations,Sickness,etc).
I want to have most of the logic on the side of the database so I want to create packages to deal with these tables.
One of the packages will be CUSTOMERS_PKG. That seems right.
But now, how should I do about the other tables? Should I have a package for each table or should I have a package like CUSTOMERS_DETAILS_PKG that handles with all the other tables?
What is the best practice?
Thank you