Basic Application Development Concepts

This section discusses the basic concepts in application development with Oracle Database Express Edition.

User interface

The interface that your application displays to end users depends on the technology behind the application as well as the needs of the users themselves. The Oracle Database XE browser-based user interface is an example of an application interface. See "Development Tools".
Client/server model

In a traditional client/server program, your application code runs on a different machine than where the database (server) is located. Database calls are transmitted from this client machine to a database, such as Oracle Database XE. Data is transmitted from the client to the server for insert and update operations and returned from the server to the client for query operations where the data is processed on the client machine.
Server-side coding

You can develop application logic that resides entirely inside the database by using PL/SQL triggers that execute automatically when changes occur in the database or stored PL/SQL procedures or functions that are called explicitly. Off-loading the work from your application lets you reuse code that performs verification and cleanup and control database operations from a variety of clients.