2.1.3 Database Views, Triggers, and Packages

While tables store your application data, it's important to understand how views, triggers, and packages complement them.

While you define a view using SQL, you write triggers, procedures, functions, and packages in PL/SQL, the procedural language extension to SQL. If your database is Oracle 26ai, you can also use JavaScript.

The Object Browser in App Builder lets you easily create and maintain any tables, views, triggers, and packages that your application requires.

• Database Views
  A database view is a named SQL query you can reuse to simplify data access across your APEX applications.
• Database Triggers
  Database triggers are a useful way to validate data and compute column values in one place, no matter which application access it.
• Database Packages
  Database packages contain a specification of available procedures and functions. Oracle recommends you use them to organize custom business logic.