I finally realized how powerful Oracle really is! Not database, but also low code rapid development of Web applications!! Oracle APEX technology, really niche, but excellent technology, somehow there are no learning sites, and I don’t know of any enterprise applications that use it, hasn’t anyone discovered this excellent pseudo-full stack technology? ! I feel I am only one APEX away from full stack engineer!!

Understanding of Oracle APEX

Oracle Application Express (Oracle APEX), formerly known as HTML DB, is a fully supported “no-cost” option for Oracle databases. Oracle Application Express is certified for all versions and higher of Oracle Database 10.2.0.3, Includes Oracle Database 10G Express Edition (Oracle XE).

The latest version of Oracle Application Express is available for free download from Oracle Technology Network (OTN) [otn.oracle.com/apex]

What does Oracle APEX fit into?

Oracle APEX is suitable for enterprise applications, i.e. ERP, CRM and other management applications.

This type of product is characterized by less UI and concurrency requirements than Internet products, but at the same time, the business logic is relatively more complex, more suitable for internal use of enterprises.

Oracle APEX can complete all the work of front-end and back-end, and basically belongs to zero code development. No matter in terms of development efficiency or development quality, it is not comparable to traditional enterprise development tools or technologies, which will be deeply understood in the later use process.

The browser is the IDE? Only APEX, pseudo-full stack development!!

With a Web browser and some programming experience, data-centric applications can be developed in minutes.

On most computers, with browser-based development, applications can be developed using only a modern Web browser.

JDK+Tomcat+Maven+IDE + HTML + CSS and so on are not needed!!

All you need to install is Oracle APEX, a browser, and you can do full stack web development!!

Rapid Application Development (RAD)

You can create powerful reporting and data entry applications using simple wizards and declarative programming.

How to create an application:

  • Create an application from an uploaded spreadsheet
  • Create from existing database tables and views
  • SQL Studio, where database objects that support applications can be created and managed

Declarative development

What is declarative development?

The code in Application Express is declarative:

  • This means that instead of generating or compiling code, you just interact with wizards and properties worksheets.

  • If procedural logic is required, code snippets can be written using PL/SQL.

  • The Application Express engine renders applications in real time using data stored in database tables. Oracle Application Express creates or modifies metadata when an Application is created or extended. When the Application runs, the Application Express engine then displays pages based on metadata or handles page submission operations.

2. Advantages of declarative development

  • Declarative code makes little difference between developers, and this consistency enables applicationsEasy to maintain and manage.
  • Multiple developers can edit the same page, and the changes take effect immediately when the application runs,No compilation or deployment effort is required.

Oracle Application Express declarative programming examples

  • The form

The wizard makes it easy to create forms on tables or stored procedures. These wizards automatically manage inserts, updates, and deletions when creating forms on tables, and can detect missing updates. Once the form is created, you can rearrange the form fields (called form items) using an intuitive presentation to quickly achieve the desired layout.

  • Interactive Reports To create interactive reports, developers can select tables or provide SQL statements. Developers can then limit the functionality provided to end users as needed (for example, disable downloads, do not allow hidden columns). The end user will see the report, and the functionality is the same across all reports in the application (for example, how to filter, highlight, subscribe, and save custom views).

  • Session state Oracle Application Express transparently manages session state in the database. Without the need for sets and GETS, Oracle Application Express handles everything for you. Application developers can access session state using simple substitution and standard SQL binding variable syntax.

Creating a process to clear the session state of a page is as simple as a few mouse clicks and specifying the desired page.

Application Express components

Application builder: database application

  • Application developers use wizards to declaratively assemble page-organized applications.

  • Page content is organized into areas. Areas can contain text, custom PL/SQL, reports, charts, maps, calendars, Web service references, or forms.

  • Forms consist of fields (called “items”) that can be selected from multiple built-in types (such as text fields, text areas, radio groups, select lists, check boxes, date pickers, and pop-up value lists), or developers can create their own types using plug-in support.

  • Table update functionality is built in and can be used to process data using PL/SQL.

  • Session state (or application context) is transparently managed, and the user interface representation is independent of the application logic, so the appearance of the application can be changed simply by selecting different topics.

2. Application Builder: Websheets

  • Using the Websheet application, finallyUsers can manage structured and unstructured data without developer assistance.
  • Page extents contain unstructured data and can be usedWYSIWYG editorThe editor.
  • Reports provide the ability to access database data by writing SQL.
  • Data grids can manage structured data whileNo need to write SQL.
  • Use the runtime dialog to define how to add columns, rename columns, and perform validation.
  • Every page and line of data in the data grid can be annotated using files, tags, comments, and links.
  • Pages can contain sections as well as reports and data grids, and all of these can be linked together to provide navigation.
  • All information is searchable and fully controlled by the end user.

3. SQL Studio

  • SQL Studio provides tools that you can use to view and manage database objects.

  • The object browser allows you to view object properties and create new objects using tree controls.

  • Use the SQL command tool to enter temporary SQL.

  • Join queries can be created using drag-and-drop functionality through the query builder.

  • With SQL scripts, you can store and run scripts.

  • Using data Studio you can load and unload text, DML and spreadsheet data.

4. Group development

  • Team development helps manage the application development lifecycle.

  • It provides tracking and management of application features, to-do items, bugs, and end-user feedback.

  • Team development is tightly integrated into the Oracle APEX application builder.

For example, editing a page lists open feedback, bugs, and to-do items.

5, management,

  • Each Oracle APEX workspace is a separate application development environment completely isolated from the other workspaces.
  • The admin component providesWorkspace management function, including services (available options, space requests, and preferences), users (This includes both developers and end users) and workspace activities (page access, login attempts, and developer activities).
  • Access is restricted to Oracle APEX developers with workspace administration privileges.

This article was automatically published by ArtiPub