Execute PL/SQL Procedure with IN and OUT Parameters in Oracle
Requirement: I want to execute the PL/SQL Procedure with IN and OUT Parameters in Oracle. Solution: For the solution of…
Oracle Function to Validate if the Provided Value is in Numeric Format
Requirement: I want to validate if the user-provided value is in Numeric format. Solution: For the solution, of the above requirement let us create…
Oracle Function to Validate if the Input Date is in DD-MM-YYYY Format
Requirement: I want to validate if the user provided Date value is in DD-MM-YYYY format. Solution: For the solution, of…
ORA-00838: Specified value of MEMORY_TARGET is too small
Explanation: Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300…
Get and Set the ORACLE_HOME path in Windows
Requirement: In this post, I will describe some of the processes to get the ORACLE_HOME path. After we have the…
validate_con_names: ORCLPDB is not open
Problem Statement: At the time of Installing Oracle APEX, when I fired the @apexins APEX_SPACE APEX_SPACE TEMP /i/ command, I…
Install Oracle Database Express Edition 18c on Windows
Requirement: In this post, I will describe the various steps that are required to install Oracle Database Express Edition (XE) Release 18.4.0.0.0…
Uninstall Oracle Database 19c on Windows
Requirement: In this post, I will describe the various steps that are required to uninstall Oracle Database 19c from the Windows 10 Operating System.…
Install Oracle Database 19c on Windows
Requirement: In this post, I will describe the various steps that are required to install Oracle Database 19c on the…
Display Week Number, Start Date, and End Date for a specific week in Oracle SQL
Requirement: I want to have an Oracle SQL query where I will pass a random Date value, and as a…