Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

How to use dynamic SQL with DBMS_SQL

Posted on 23/09/202323/09/2023 by admin

In this post, I am going to show how to use dynamic sql in PL/SQL. DBMS_SQL package has been used for this. I prepared the following example in […]

More Details
Posted in PL/SQL, SQLLeave a Comment on How to use dynamic SQL with DBMS_SQL

ORA-01704 string literal too long

Posted on 28/06/202304/07/2023 by admin

ORA-01704 error occurs when a string literal more than 4000 characters in SQL. In the example below the string length is exactly 4000 characters. So, if one character […]

More Details
Posted in SQLLeave a Comment on ORA-01704 string literal too long

How to fix cardinality misestimate?

Posted on 26/05/202308/06/2023 by admin

In this post, I am going to explain how to correct the cardinality estimate in 5 different methods. Cardinality estimate is one of the first place to check […]

More Details
Posted in DBALeave a Comment on How to fix cardinality misestimate?

CUME_DIST function

Posted on 05/05/202305/06/2023 by admin

In this post, I would like to explain a function that is not well known. CUME_DIST analytic function is used for calculating the cumulative distribution of a data […]

More Details
Posted in PL/SQLLeave a Comment on CUME_DIST function

FOR UPDATE vs FOR UPDATE SKIP LOCKED

Posted on 31/01/202302/02/2023 by admin

In this post, I am going to explain how FOR UPDATE and FOR UPDATE SKIP LOCKED clauses work. I would like to demonstrate it with a basic example. […]

More Details
Posted in PL/SQLLeave a Comment on FOR UPDATE vs FOR UPDATE SKIP LOCKED

NVL vs COALESCE

Posted on 28/10/202229/06/2023 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/202212/09/2023 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

Posts navigation

Older posts

Recent Posts

  • How to use dynamic SQL with DBMS_SQL
  • ORA-01704 string literal too long
  • How to fix cardinality misestimate?
  • CUME_DIST function
  • FOR UPDATE vs FOR UPDATE SKIP LOCKED

Recent Comments

  • admin on How to generate, parse and use JSON data
  • Johann on How to generate, parse and use JSON data
  • admin on How to reorder columns of table
  • Yogendra on How to reorder columns of table
  • ENOCK OLOO on Data encryption and decryption using PL/SQL

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery

Flag Counter

© Copyright 2023, Çağlar Polat