|
Oracle APEX
Application Express enables Oracle database users, including those with limited technical skills, to create and manage secure Web applications using only a Web browser. The tool can be used to prototype Web-based applications as well as run those applications supporting tens to thousands of users.Excelencia has dedicated professionals who have worked on APEX and delivered robust solutions. We offer the following services:
- APEX installation, administration, upgradation, performance tuning, troubleshooting, making modifications, managing test & production systems, securing application, managing users
- Configure, administer, manage & maintain Oracle APEX infrastructure
- Application development
- Training Onsite/offsite
|
APEX Advantages
- Quick assembly of reporting and data entry applications
- Based on existing tables and views
- No programming or scripting
- Instant deployment on the Web
- No client software is required to develop, deploy, or run Application Express
Advantages over traditional Oracle Forms
- Need not be installed on every client machine like Oracle Forms
- Works on any kind of browser available
- Security – Authorization can be applied to each page, tab, components
- Easier to adopt and implement
- Centrally deployed and managed
Application Express Architecture
Oracle Application Express consists of a metadata repository that stores the definitions of applications and an engine (called the Application Express engine) that renders and processes pages. It lives completely within your Oracle database. It is comprised of nothing more than data in tables and large amounts of PL/SQL code. The essence of Oracle Application Express is approximately 215 tables and 200 PL/SQL objects containing 300,000+ lines of code.
The Application Express engine performs:
- Session state management
- Authentication services
- Authorization services
- Page flow control
- Validations processing
- Rendering and page processing
Application Express using the Oracle HTTP Server (Apache) with mod_plsql
Oracle Application Express using the Embedded PL/SQL Gateway
The key features of Oracle Application Express, includes:
- Reporting
- Forms
- Charting
- PDF Printing
- Web Services
- Spreadsheet Upload
- Session State Management
- User Interface Themes
- Flow Control & Navigation
- Conditionality on all Components
- External Interfaces & Extensibility
- Declarative BLOB Support
- Optional Runtime-Only Installation
- Security
- SQL Workshop Tools
- Supporting Objects Utility
- Performance
- Packaged Applications
- Hosted Development
|
|
