Category: Oracle Apex theme

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 +

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 +

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 +