Oracle Apex Tutorial by Azhar Uddin

What Is Oracle Apex ?

Oracle Application Express is a free Oracle product that enables developers to quickly create web based applications on an Oracle database by using just a web browser. The APEX tool runs in a web browser and allows the creation of web applications in a declarative manner, by simply selecting pre-built components, configuring them and bundling them up in a web application, all without the need to write too much code.

APEX can be downloaded from the official Oracle website, together with documentation: HTTP://BIT.LY/8ZDMSA

Application Express (otherwise known as APEX) is a web application that is tightly coupled to an Oracle Apex Training database. It has several uses: you can use its SQL Workshop tool to query the database, modify its contents, or change its structure; you can use its Application Builder tool to create your own web applications that interact with the database; and you can run the web applications created by you and others.

The application builder is especially interesting because it provides a simple, nontraditional way to build web pages. You do not specify code for the page directly; instead, you choose from a set of built-in templates. There is a template for the overall page and templates for each kind of component that you want to put on the page (such as reports, buttons, and so on). Each template has a set of properties, whose values determine where each component is located on the page, what it looks like, and how it behaves. You create a page simply by choosing templates for the components you want and assigning values to their properties.

The APEX application builder saves the property values for each component in a private database. When a browser requests one of your application’s pages, the APEX server extracts the property values relevant to that page from its database, constructs the HTML code corresponding to those values, and returns that code to the browser. This process is called rendering the page, and APEX is called an HTML generator.

Sponsor Ads