Here I am giving an example to display the external file in a region in Oracle Apex. In Oracle, you can access external files using the Oracle directory object. Suppose you have the external files on the server directory /oracle/usr/emp/docs, ...
Home/Blog
Discy Latest Articles
Oracle PL/SQL Download BLOB File to Disk
VinishHere is an example of Oracle PL/SQL stored procedure to download BLOB file to disk. Oracle PL/SQL Stored Procedure Example to Download BLOB as File The following PL/SQL procedure takes three arguments. First, Oracle Directory object name, second, file name, ...
Oracle Convert External File to BLOB
VinishHere is an example of the Oracle PL/SQL program to convert an external file to BLOB. Oracle PL/SQL Function Example to Convert an External File to BLOB In Oracle, you can reference an external file using the BFILENAME() function by ...
Oracle Apex Calendar Example
VinishIn this tutorial, you will learn how to create a Calendar in Oracle Apex and create events, delete events, etc. Creating a Table for Calendar To create a calendar in Oracle Apex, you should have a table containing columns to ...
Oracle Apex - Open Modal Dialog Page Using JavaScript
VinishHere is an example to open a modal dialog page using JavaScript in Oracle Apex. This example will call a modal dialog page (page number 27) from a normal page (page number 25). Page 25 having a page item P25_EMP_ID, ...
Oracle SQL Query to Find Substring in String
VinishHere are examples of Oracle SQL queries to find substring in a string. Find Substring in a String Using INSTR() Function Examples In Oracle, the instr() function returns the position of a substring in the string. So if the substring ...
Oracle Apex - Copy Page
VinishIn this tutorial, you will learn how to create a page as a copy of another page in the Oracle Apex application. Oracle Apex - Steps to Create a Page as Copy of Another Page To create a page as ...
Oracle SQL Query to Fetch First n Rows
VinishHere are examples of Oracle SQL queries to fetch first n rows. Oracle SQL - Fetch First n Rows Examples You can use the FETCH FIRST clause to get the first/top n rows in Oracle. Below is an example: SELECT ...
Oracle SQL Query to Get Invalid Objects
VinishHere are examples of Oracle SQL queries to get invalid objects. Get Invalid Objects of Current User in Oracle To get the list of invalid objects for the current logged in user, run the following SQL query: Select object_name, object_type, ...
Oracle SQL Query to Join Two Tables
VinishHere are the examples of Oracle SQL queries to join two tables. Using INNER JOIN to Join Two Tables in Oracle The following SQL query will join the emp and emp_docs table using the INNER JOIN clause: select e.first_name, e.last_name, ...