XML Insights with Oracle
Jan 21 · 8 min read · 1) XML in Oracle SQL (XML to table) Key Data Types & Functions XMLTYPE: Native type to store and query XML. XPath/XQuery via: XMLTABLE (preferred for shredding XML into rows/columns), XMLQUERY, XMLCAST, Legacy EXTRACT() / EXTRACTVALUE() (depreca...
Join discussionWhy Learning Oracle SQL is Essential for Every Aspiring Developer
Jul 28, 2025 · 6 min read · In the modern era of data-driven decision-making, structured data is more valuable than ever. Every click, transaction, or entry on a digital platform creates data that needs to be stored, retrieved, and analyzed efficiently. This is where relational...
Join discussion
Introduction to PL/SQL
Feb 3, 2025 · 8 min read · PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL. It is a powerful, block-structured language that enables developers to write complex database applications with procedural constructs like lo...
Join discussionSQL - Calculating Date Offset While Excluding Weekends
Oct 15, 2024 · 2 min read · In a current project, I needed to calculate the date offset while excluding weekends. Initially, this was solved using a loop in PL/SQL, which I consider a less efficient approach. To optimize it, I created a straightforward SQL query that handles th...
JJared commentedDatatype in Oracle SQL
Aug 28, 2024 · 2 min read · DataType Data type is used to specify the type of data that will be stored in a particular memory location. Types of Data Type CHAR VARCHAR/ VARCHAR2 NUMBER DATE LARGE OBJECT CHARACTER LARGE OBJECT BINARY LARGE OBJECT CHAR CHAR datatype ...
Join discussion
Introduction to SQL
Aug 27, 2024 · 3 min read · SQL SQL stands for Structured Query Language Data Data is a raw fact which describes the properties of an object. Properties is also known as attributes Object is also known as entity P.S. Focus on the concept not on how beautiful Julli looks I...
Join discussion
Data Integrity for Fast Refresh Materialized Views with Aggregates and Updates/Deletes
Jan 8, 2024 · 5 min read · Update: thanks to Connor McDonald for pointing out how to fix this issue (see "The Solution" and subsequent explanation below). Connor wrote a followup post based on this article discussing count(*) vs count(1) differences. The Problem I recently had...
CConnor commented