Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: PL/SQL

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

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

How to make your PL/SQL code faster

Posted on 27/12/202108/06/2023 by admin

In this post, some important points of PL/SQL performance metrics has been explained. Oracle 19c has been used in all examples. Use Bind Variable Using bind variables can […]

More Details
Posted in PL/SQLLeave a Comment on How to make your PL/SQL code faster

PL/SQL Exception Handling in All Details

Posted on 15/12/202129/08/2022 by admin

Exception management is one of the most important part of all programming languages. Having a good understanding of this topic will help you a lot in debugging. In […]

More Details
Posted in PL/SQLLeave a Comment on PL/SQL Exception Handling in All Details

How to get OS environment variables in PL/SQL

Posted on 01/11/202101/11/2021 by admin

If you need to find out the value of any OS environment variable, such as ORACLE_HOME, without connecting your remote server. You can use DBMS_SYSTEM.GET_ENV procedure as shown […]

More Details
Posted in DBA, PL/SQLLeave a Comment on How to get OS environment variables in PL/SQL

The easiest way to use Java in Oracle

Posted on 03/05/202108/05/2021 by admin

There are several methods to use Java in Oracle. I am going to show the easiest way. Basically, the Java interpreter starts running the application by calling main() […]

More Details
Posted in PL/SQL4 Comments on The easiest way to use Java in Oracle

How to get the contents of unknown SYS REFCURSOR

Posted on 08/02/202108/02/2021 by admin

You can use the following procedure in order to get the unknown number of columns and column types.

More Details
Posted in PL/SQLLeave a Comment on How to get the contents of unknown SYS REFCURSOR

How to open pluggable database automatically

Posted on 02/01/202102/01/2021 by admin

There are different startup phases of Oracle database. In multitenant architecture, startup and shutdown commands of container database are same as the regular database. After opening the container […]

More Details
Posted in PL/SQLLeave a Comment on How to open pluggable database automatically

Posts navigation

Older posts

Recent Posts

  • How to fix cardinality misestimate?
  • CUME_DIST function
  • FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • NVL vs COALESCE
  • How to use MULTISET UNION DISTINCT on collections

Recent Comments

  • 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
  • Soeren Dalby on How to generate, parse and use JSON data
  • Nicolas on Print clob data with htp.prn

Archives

  • May 2023
  • 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

Flag Counter

© Copyright 2023, Çağlar Polat