In this guide, we'll explore how to implement the 'On Key Enter Go To Next Item' functionality in Oracle APEX, which allows users to press the Enter key to move the focus to the next item in the form. This ...
Discy Latest Articles
How to Null + 1 in PL/SQL?
When working with nullable fields, it's important to understand that NULL does not behave like a typical numeric value. If you try to add 1 to a NULL in PL/SQL (null + 1), the resulting value will itself be NULL ...
Null in PL/SQL: Definition, Uses, and Best Practices
In PL/SQL, null represents the absence of a value or the unknown state. It is not the same as zero or an empty string; rather, it signifies the absence of any defined data. It can be used to indicate missing ...
PL/SQL GOTO Examples
In this tutorial, we will explore the GOTO statement examples in PL/SQL, a procedural extension of SQL used in Oracle databases. The GOTO statement is a control structure used to alter the flow of execution in a program. While it's ...
PL/SQL CASE Examples
The PL/SQL CASE statement is a control structure that allows you to execute a sequence of statements based on a condition or the value of an expression. It's akin to the switch statement in other programming languages and provides a ...
PL/SQL IF Condition Examples
Welcome to a detailed tutorial on using IF conditions in PL/SQL. PL/SQL, Oracle Database's procedural extension to SQL, offers robust control structures like IF conditions. These conditions are essential for decision-making in your PL/SQL programs, enabling you to execute code ...
How to Start a Programming Blog? Comprehensive Guide
So You Want to Start a Programming Blog? Here's How to Do It Right. Have you been considering starting a programming blog but feel overwhelmed by all the options and decisions involved? Don't worry - with the right strategy and ...
How to Create a Table in PL/SQL Procedure in Oracle?
In Oracle PL/SQL, you can create a table within a PL/SQL procedure using the EXECUTE IMMEDIATE statement to execute a dynamic SQL statement that contains the CREATE TABLE statement. Here's a step-by-step guide on how to create a table in ...
Oracle Apex Collection: Update Member Examples
In this tutorial, you will learn how to update collections in Oracle Apex using the APEX_COLLECTION.UPDATE_MEMBER procedure. In Oracle Application Express (Oracle Apex), the capability to manage collection members is fundamental for dynamic data handling. Here, we'll explore the APEX_COLLECTION ...
How to Create a Collection in Oracle Apex?
You can use apex_collection.create_collection procedure to create a collection in Oracle Apex. In this tutorial, you will learn how to create collections and add data to them in Oracle Apex. What is Collection in Oracle Apex Before we learn how ...
Can Oracle Database Run on MAC?
The straightforward answer is No. You can not run Oracle Database on MAC OS. Oracle Database is a relational database management system (RDBMS) that stores data in tables and other objects. Oracle Database can run on Windows, Linux, and UNIX ...
Oracle APEX JavaScript - Get Column Value
Do you want to get the Interactive Grid column value using JavaScript in Oracle Apex? If yes, then please check the below example: Get IG Column Value Using JavaScript in Oracle Apex In the following example, it will get the ...
Oracle Apex - Get Item Value Using JavaScript
In Oracle Apex, use apex.item("ITEMNAME").getValue() or $v("ITEMNAME") JavaScript methods to get item value. Below are the examples: Example 1: Get Item Value using apex.item().getValue() JavaScript Method In the following JavaScript program, it will get the P2_TOTAL item value (total amount) ...
What is the difference between constraints and triggers in Oracle?
In this tutorial, First, we would be discussing what is constraints and their types, and secondly, about the Oracle triggers and the usages before we could see the major difference between constraints and triggers. CONSTRAINTS: In Oracle, the constraints are ...
Oracle Apex - Display External File in Region
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, ...
Oracle PL/SQL Download BLOB File to Disk
Here 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
Here 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
In 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
Here 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
Are you looking to find specific words or pieces of text inside a longer text in Oracle SQL? Well, you're in the right place! In this quick tutorial, we'll show you how to use Oracle SQL to search for and ...