A single API call invokes all of the necessary data processing, based on the metadata definition, in a single request rather than requiring multiple calls to the database. This architecture guarantees zero latency data access, top performance, and scalability, out of the box. All processing, data manipulation and business logic is executed in the database. Therefore, Oracle APEX apps are very efficient as data is manipulated directly in the database, and the results are sent back to your web browser. Oracle APEX uses a simple 3-tier architecture where requests are sent from the browser, through a web server, to the database. There is no need for file-based compilation and there is no code generation.Īll processing is performed by PL/SQL acting directly on the data schemas in the database. Application developers can get and set session state using simple substitutions as well as standard SQL bind variable syntax. A Create Table window will appear, as shown in below example. Select New Table option from the shortcut menu to create a table. Then select Table node and do the right click on it. To provide stateful behavior within an application, Oracle APEX transparently manages session state in the database. On the left side, click on the schema name to expand the node. When the application is run, the Oracle APEX engine then reads the metadata and displays the requested page or processes page submissions. When you create or extend an application, Oracle APEX creates or modifies the metadata stored in its database tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |