Integrating Oracle APEX (18.2) with Microsoft Power BI (Oracle RESTful Data Services)

Lately we can see how much has been spoken of Business Intelligence, the famous BI, and the tools that encompass this world. One of them, well known by signal, is Microsoft's Power BI. Thinking about this and how Oracle APEX has been prominent in the development of web and mobile applications, how could we combine the best of the two? I mean, how could we use Power BI to graphically display data generated in Oracle APEX and bring value to a company's business through its data

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

Creating a Custom Authentication Schema [APEX 18.1]

In this post we will see how to create a custom authentication scheme in Oracle Application Express (APEX) based on a database table. For this, we will create a user table and a function that will be responsible for validating users who may or may not have access to the system. Note: In this article we will not focus on the security part, password encryption, etc. This article aims to show in a simple way the creation of a custom authentication scheme. Description To build ou

Query an address from a Web Source Module [APEX 18.1]

In this example, we will learn how to create and consume data from a Web Source Module in Oracle Application Express (APEX) 18.1. It is very simple and useful! What is a Web Source Module in Oracle APEX? Web Source Modules allow developers to access REST services or JSON data in applications, enabling the use of this data in APEX components such as interactive reports and forms. Unlike Web Services references, a Web Source Module contains Web Service metadata that can be used