Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: SQL

NVL vs COALESCE

Posted on 28/10/202228/10/2022 by admin

As it is known, NVL and COALESCE functions are used in order to eliminate NULL values. However, NVL function is much more popular in comparison with the COALESCE. […]

More Details
Posted in SQLLeave a Comment on NVL vs COALESCE

How to use MULTISET UNION DISTINCT on collections

Posted on 25/04/202227/04/2022 by admin

Let’s start with a basic example. Suppose, you have two PL/SQL collections with the same data type that you want to merge and remove the repetitive data. You […]

More Details
Posted in PL/SQL, SQLLeave a Comment on How to use MULTISET UNION DISTINCT on collections

How to use PL/SQL functions within SQL

Posted on 08/03/202222/03/2022 by admin

As it is known, invoking PL/SQL code from SQL cause context switching. SQL is a non-procedural language and it is very different from PL/SQL language. In addition, PL/SQL […]

More Details
Posted in PL/SQL, SQLLeave a Comment on How to use PL/SQL functions within SQL

The power of MATCH_RECOGNIZE

Posted on 24/02/202224/02/2022 by admin

MATCH_RECOGNIZE is one of the most powerful feature of SQL. There are several use cases, such as finding series of consecutive rows, pattern matching, etc. Once you understand […]

More Details
Posted in SQLLeave a Comment on The power of MATCH_RECOGNIZE

LISTAGG Enhancements

Posted on 31/01/202210/02/2022 by admin

If you consider to aggregate data from multiple rows into a single column, LISTAGG might be the first function that comes to your mind. It has been enhanced […]

More Details
Posted in SQLLeave a Comment on LISTAGG Enhancements

WITH clause and Depth First Search

Posted on 27/01/202227/01/2022 by admin

In this article, I am going to explain how you can implement the depth first search with using the WITH clause or also known as subquery factoring clause. […]

More Details
Posted in SQLLeave a Comment on WITH clause and Depth First Search

How to reorder columns of table

Posted on 23/01/202227/01/2022 by admin

If you want to change the order of the columns of any table without recreating it, then the following trick will work for you. Suppose you want to […]

More Details
Posted in SQL1 Comment on How to reorder columns of table

5 Life Saving Features of Oracle

Posted on 16/06/202117/01/2023 by admin

1) Partitioned Outer Join I would like to start with PARTITIONED OUTER JOIN. Because it is one of the least used feature. Suppose that you have two basic […]

More Details
Posted in DBA, SQL1 Comment on 5 Life Saving Features of Oracle

How to generate, parse and use JSON data

Posted on 11/04/202126/10/2021 by admin

In this article, I will explain how easily you can generate, parse and use JSON data in the Oracle database. I used Oracle 19c for all examples in […]

More Details
Posted in SQL1 Comment on How to generate, parse and use JSON data

Useful Oracle Functions

Posted on 19/03/202129/12/2021 by admin

How to find the difference between two dates If you want to find the difference between two dates according to different time types, you can use the EXTRACT […]

More Details
Posted in SQLLeave a Comment on Useful Oracle Functions

Posts navigation

Older posts

Recent Posts

  • FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • NVL vs COALESCE
  • How to use MULTISET UNION DISTINCT on collections
  • How to use PL/SQL functions within SQL
  • The power of MATCH_RECOGNIZE

Recent Comments

  • ENOCK OLOO on Data encryption and decryption using PL/SQL
  • Soeren Dalby on How to generate, parse and use JSON data
  • Nicolas on Print clob data with htp.prn
  • Anonymous on Unlock Apex admin account
  • Anonymous on How to reorder columns of table

Archives

  • January 2023
  • October 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • May 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery
© Copyright 2023, Çağlar Polat