DUO Two Factor Authentication Using PL/SQL

DUO Two Factor Authentication Using PL/SQL

This tutorial will teach you how to integrate DUO Two Factor Authentication using PL/SQL in the Oracle database. What is Two Factor Authentication? Two-factor authentication (2FA) is a method by which users can verify their identity by using two different…

Best Oracle Apex Books

Best Oracle Apex Books

Oracle Application Express or Oracle APEX is one of the greatest platforms for creating and managing web applications. Today several large-cap companies use Oracle APEX for managing their databases. If you are looking for a career in Database Management or…

Does AWS support Oracle APEX?

Does AWS support Oracle APEX?

Amazon Web Services or AWS offers numerous cloud solutions for migrating and deploying enterprise applications on its platform. Using AWS's inherent qualities, customers can launch their complete business software stacks on the AWS cloud. On the other hand, you can…

Best Hosting Solutions for Oracle Apex

Best Hosting Solutions for Oracle Apex

Here in this blog, we will be discussing Oracle APEX, a look into the best Oracle APEX Hosting Providers, and different parameters to compare. So sit tight and read on. What is Oracle Apex? Oracle APEX or Oracle Application Express…

Oracle Pipelined Function Example

Oracle Pipelined Function Example

This Oracle tutorial shows how to create Pipelined function. Follow these steps: 1. Create a Type Object For Oracle pipelined function, we must have a type object through which we can send the rows. Create one as below: CREATE OR…

Creating Breadcrumbs in Oracle Apex

Creating Breadcrumbs in Oracle Apex

Breadcrumbs are useful for any web application to navigate to the home or parent pages easily. Also, it increases the look and feel of the page by showing the page hierarchy. In this tutorial, you will learn how to create…

Get BLOB from the BFILE Column in Oracle

Get BLOB from the BFILE Column in Oracle

In Oracle, the BFILE column is a locator or reference for the external file. It has the directory and filename information. Here I am giving an example of PL/SQL code to get BLOB from the BFILE locator column in Oracle.…

APEX_ZIP Example

APEX_ZIP Example

In Oracle 12c onwards, on which the Oracle Apex is by default installed, you can use APEX_ZIP PL/SQL package to zip the files. So here I am giving a few Oracle APEX_ZIP examples: Oracle APEX_ZIP Example The following PL/SQL code…