When testing any subprogram that is not defined in the outer layer, I have to put an additional exception handler in each unit test to catch the PLSQL exception and then call ...

Built an Oracle SQL and PL/SQL-based inventory system with normalized tables, constraints, and indexing. Developed procedures, functions, and triggers for real-time stock updates, reorder checks, and ...