Best type of join to use Understanding the Best Type of SQL Join to Use When working with relational databases joining tables is a common operation that allows you to combine data from 3 min read 30-09-2024 51
Non existent path or file when reading a file in a network shared drive, in Oracle DB 21c XE? Resolving Non existent Path or File Error in Oracle DB 21c XE When Accessing Network Shared Drives Accessing files stored on a network shared drive from Oracle 3 min read 24-09-2024 86
SQL Updating a table column from first 9 digits of another column Updating a Table Column Using the First 9 Digits of Another Column in SQL In SQL updating a table can sometimes require extracting specific parts of a column to 2 min read 15-09-2024 61
Query performance issue when adding UNION to CTE/Query Understanding Query Performance Issues When Adding UNION to CTE Query When working with complex SQL queries performance issues can arise particularly when using 3 min read 14-09-2024 50
How to replace dbms_obfuscation_toolkit with dbms_crypto Migrating from DBMS OBFUSCATION TOOLKIT to DBMS CRYPTO in Oracle 21c Oracles DBMS OBFUSCATION TOOLKIT package used for data encryption and decryption was deprec 2 min read 04-09-2024 52
Use of like "%" character in sql query changes my query when executed as shell script Understanding the Perils of Percent Signs in SQL Queries Within Shell Scripts This article delves into the common issue of using the character within SQL querie 2 min read 03-09-2024 69
Compound trigger Understanding Compound Triggers and Their Use Cases Compound triggers in Oracle are powerful tools that allow for more complex and flexible trigger logic compar 3 min read 29-08-2024 54
My Oracle database 21c express is duplicating my query result in the result tab My Oracle Database 21c Express is Duplicating My Query Results Its frustrating when your Oracle Database 21c Express starts behaving unexpectedly especially whe 3 min read 27-08-2024 44