Category: Oracle Apex theme

Classic and Interactive reports in Oracle Apex

Oracle Apex

Interactive reports: Interactive reports is a formatted result of a SQL query. Interactive reports can be created with both Create Application Wizard and Create Page Wizard. It supports only Desktop applications. Users can customize the report layout and data displayed. Multiple interactive reports per page can be included and developers can restrict the capabilities available to end users. In the application Report functionality, is the same across all reports. End users can customize how and what data displays while viewing an interactive report. By default, in the first column of each row, interactive reports include a search bar, an Actions menu, column heading menus, and edit icons. Classic Reports: A classic report is a formatted result of a SQL query. Classic report creation is supported by both the Create Application Wizard and Create Page Wizard. End users cannot customize a classic report except for sorting and simple filtering. To create a classic report, developers either select a table or provide a SQL statement. Classic reports support general keyword search capability, the ability to specify the number of rows that display, and basic column sorting. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more […]

Read More +

Passing page items from one page to another page in Oracle Apex

Oracle Apex

A page in Oracle Apex can access data entered on another page if that data has been saved in session state or an APEX collection or if it has been committed to a database table. There are two methods to pass items between two pages. One way to pass data is to submit the page and then use a branch to redirect to the next page. This enables validations and processing to be applied. Data can be passed to the next page through collections, tables or by explicitly setting session state items in the next page. The second way of passing is to call a page process using ajax or use an Execute PL/SQL dynamic action. Here the process is performed through a Execute PL/SQL dynamic action (or an ajax call back process) and a dynamic action is used on the button that opens the dialog that first calls the server side processing. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250-customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

How to link a page from a master detail form in Oracle Apex

Master Detail form in Oracle Apex

A master detail form in Oracle Apex reflects a one-to-many relationship between two tables in a database. Typically, a master detail form displays a master row and multiple detail rows. One of the reasons to create a separate page is to easily edit the detail records. Since it’s difficult to perform validation on the data in a Tabular Form, having a separate form to edit an individual record makes data validation much easier.We can create two application pages in Master Details wizard where both are interactive grids. A twhttps://dataterrain.com/passing-page-items-from-one-page-to-another-page-in-oracle-apex/o-page master detail features based on two related tables or views. The first page is a non-editable interactive grid. It contains an interactive report for the master table. The second page features a standard form for the master and interactive grid for the details.We can separate the second page into two separate pages. The wizard will put the form on one page with a standard report, and another page will have a form to edit a single detail record for a total of three application pages.DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. […]

Read More +

An overview of Oracle Apex Themes and Templates

Oracle Apex Theme

Themes are collections of templates that define the layout and style of an application. The idea behind a theme is to provide a complete set of templates that accommodate every UI pattern that may be needed in an application. Theme styles are used to customize themes, to switch to a different color scheme, apply a flat look, or make a theme responsive. A theme can have multiple theme styles with one style set as active. You can modify a theme style CSS file using Theme Roller. Templates are organized first by a template type and then by template class. Template types include page, region, report, list, button, label, and popup list of values (LOV). Template options provide a declarative way to apply different styles to components on an Oracle Application Express page. You can use template options to apply different colors or accents, different spacing and padding, and display form fields with different alignments. They reduce the need to have multiple similar templates defined in a theme. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 300-customers in the US and over 70 customers worldwide. We are flexible in working hours and […]

Read More +