Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: SQL

ORA-30926 unable to get a stable set of rows in the source tables

Posted on 23/11/202029/12/2021 by admin

In this post, I am going to talk about ORA-30926 error and how to solve it. Let’s create the following tables for our example. This error occurs due […]

More Details
Posted in SQLLeave a Comment on ORA-30926 unable to get a stable set of rows in the source tables

How to split comma separated string into rows

Posted on 26/05/202029/12/2021 by admin

In rare cases we might need to convert string data into rows. So, you can simply do this using the code below. If your string is not comma […]

More Details
Posted in SQLLeave a Comment on How to split comma separated string into rows

Adaptive Cursor Sharing & Histograms

Posted on 24/05/202025/05/2020 by admin

Adaptive cursor sharing has been used in Oracle 11g first. This feature enables a single statement that contains bind variables to use multiple execution plans. According to the […]

More Details
Posted in DBA, SQL1 Comment on Adaptive Cursor Sharing & Histograms

Analytic functions & Windowing clause

Posted on 09/05/202020/01/2023 by admin

Analytic functions have been used from the early versions of Oracle. It is used in many tasks, especially reporting. In this article, I am going to use EMP […]

More Details
Posted in SQLLeave a Comment on Analytic functions & Windowing clause

SUBSTR vs DBMS_LOB.SUBSTR

Posted on 04/02/202025/05/2020 by admin

We have to choose the right built-in function when developing pl/sql applications. The following test case shows the performance outcome between SUBSTR and DBMS_LOB.SUBSTR functions. This test was […]

More Details
Posted in PL/SQL, SQLLeave a Comment on SUBSTR vs DBMS_LOB.SUBSTR

Pivot and Unpivot Operators in Oracle 11g

Posted on 27/12/201930/12/2019 by admin

PIVOT In this article you will learn how to use PIVOT and UNPIVOT operators. Basically, pivot operator allow you to transpose rows into columns. Prior to 11g, it […]

More Details
Posted in SQLLeave a Comment on Pivot and Unpivot Operators in Oracle 11g

ORA-22859 invalid modification of columns

Posted on 25/12/201925/12/2019 by admin

When you try to convert datatype CLOB to VARCHAR2, you get the ORA-22859 invalid modification of columns error even if the column is empty. In order to overcome […]

More Details
Posted in SQLLeave a Comment on ORA-22859 invalid modification of columns

Parallel Enabled Pipelined Table Functions

Posted on 24/12/201908/04/2021 by admin

In the previous article, I mentioned about pipelined table functions. In this article, I am going to talk about parallel feature of pipelined table functions. At least one […]

More Details
Posted in PL/SQL, SQLLeave a Comment on Parallel Enabled Pipelined Table Functions

Pipelined Table Functions

Posted on 20/12/201924/12/2019 by admin

Table functions are used in FROM clause of a query as if it were a regular table that return PL/SQL collections. Returning large size of collections can be […]

More Details
Posted in PL/SQL, SQLLeave a Comment on Pipelined Table Functions

XPath / XQuery / SQL

Posted on 07/01/201909/01/2019 by admin

In brief, I will compare the equivalence of SQL, XQuery and XPATH. The following XML feed is used for this purpose. Oracle 11g is used. Now, I want […]

More Details
Posted in SQL, XQueryLeave a Comment on XPath / XQuery / SQL

Posts navigation

Older posts
Newer 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