Dynamic Actions: Notifications (Alert&Confirm) [Oracle APEX 18.2]

Continuing our series of dynamic action posts, we'll look at how to use the Notifications (Alert&Confirm) in Oracle Application Express (APEX). As a practical example, we'll generate alerts when some mouse events are performed on a button. Notifications We have two types of notification actions in Oracle APEX: Alert and Confirm. Alert: Displays an alert message, with a single Ok button. Use to display information that must be responded to, by pressing the button, but continue

Dynamic Actions: Set Style [Oracle APEX 18.2]

Continuing the previous post, we will now be talking about the Dynamic Action - Set Style This Dynamic Action lets you define a style property (CSS) for the affected elements. Its use is very simple and very useful in some cases. Let's take a practical example. Case Study Suppose there is a sellers table with the percentage commission that is allowed for a particular sale. In this case, we want to validate whether or not a commission is in the amount allowed for the seller. L

Dynamic Actions: Set Value [Oracle APEX 18.2]

There are several reasons to love Oracle Application Express (APEX) and in this post we will see one of these reasons: Dynamic Actions - Set Value But... what are dynamic actions? Dynamic actions in APEX allow developers to declaratively define client-side behavior even without knowing JavaScript. With dynamic actions you can set a value for an item, hide or display a region based on developer-defined conditions or events, all very simply. Set Value In this post - which will

Viewing icons in the Interactive Report [APEX 18.1]

Want to display icons instead of data in interactive reports? In this post we will see how easy, practical and beautiful to accomplish this task in Oracle Application Express (APEX). Let's go! Description As an example, we will use an environment where we will have two tables: Tasks and Task Status. Each task must have a status, and it will be in the status column that we will display, instead of the status name, icons. Our testing environment is represented by the diagram be

Using SQL row limiting clause

In this post we will see how to limit or omit a set of rows in Oracle using the offset and fetch clauses. In versions prior to Oracle 12c, much use was made of the ROWNUM clause, however, when using it with the ORDER BY clause, the developer might not have the expected return. These new clauses are available from Oracle 12c. We will use as an example, the EMPLOYEES table of schema HR - which in our example will have only 10 records and some columns. Table HR.Employees Offset