SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Best practices on Packages - Noob here

Inês ToméJun 6 2025 — edited Jun 6 2025

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

This post has been answered by Mike Kutz on Jun 6 2025

Jump to Answer

Added on Jun 6 2025

#pl-sql, #sql/plsql

5 comments

185 views