Lucas Hirscheggerblog.lucashir.eu·Oct 15, 2024SQL - Calculating Date Offset While Excluding WeekendsIn 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...1 like·149 readsoracle-sql
Gautami Shettygautamishetty.hashnode.dev·Aug 28, 2024Datatype in Oracle SQLDataType 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 ...Oracle-Sqloracle-sql
Gautami Shettygautamishetty.hashnode.dev·Aug 27, 2024Introduction to SQLSQL 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...Oracle-Sqloracle-sql
Martin Giffy D'Souzatalkapex.com·Jan 8, 2024Data Integrity for Fast Refresh Materialized Views with Aggregates and Updates/DeletesUpdate: 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...1 like·799 readsOracle
Martin Giffy D'Souzatalkapex.com·Jan 5, 2024How to Get a Non-Aggregate value in an Aggregate QuerySuppose you want to find the maximum salary for each job in the emp table. This is very easy using using the max aggregate: select job, max(sal) max_sal from emp group by job order by job ; JOB MAX_SAL --------- ------- ANALYST 3000 CL...4 likes·527 readsOracle
Martin Giffy D'Souzatalkapex.com·Jan 3, 2024Dot Notation for JSON in Oracle SQLWhen dealing with Oracle SQL statements and the need to parse JSON arises, you've likely encountered the json_value function. However, Oracle offers a more straightforward approach through simple dot-notation access to JSON data. This feature can sim...3 likes·508 readsoracle-sql
Martin Giffy D'Souzatalkapex.com·Nov 26, 2023APEX_STRING.SPLIT, Pipelined Functions, and Pickler FetchesWell that's a loaded title! Most developers may not know what each term means and as such this article will break down each item then group it all together. apex_string.split apex_string.split allows you to split a delimited string into rows (similar...1 like·1.8K readsoracle-sql
Martin Giffy D'Souzatalkapex.com·Nov 25, 2023Oracle SQL Listagg for ClobsIn Oracle the listagg function is limited to 4000 characters. If the resulting string exceeds 4000 characters then an error is raised. Example: with data as ( -- Generates: -- - Numbers each 20 digits in length -- - Alph...2 likes·1.9K readsoracle-sql
Martin Giffy D'Souzatalkapex.com·Nov 25, 2023How to merge JSON objects in SQLWhen working with APEX, handling JSON data structures is a common task, particularly when interacting with REST APIs. There may be instances where you need to merge or layer one JSON object onto another, such as when using default configurations in a...655 readsSQL
Pavan Potharajpavan5.hashnode.dev·Oct 12, 2023SQL DataTypesData Types:In SQL (Structured Query Language), a datatype specifies the type of data that can be stored in a column of a table. It defines the kind of values that a column can hold, such as integers, strings, dates, etc. Each column in a table must h...1 likeoracle-sql