CUME_DIST function
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 DetailsCategory: PL/SQL
FOR UPDATE vs FOR UPDATE SKIP LOCKED
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 DetailsHow to use MULTISET UNION DISTINCT on collections
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 DetailsHow to use PL/SQL functions within SQL
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 DetailsHow to make your PL/SQL code faster
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 DetailsPL/SQL Exception Handling in All Details
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 DetailsHow to get OS environment variables in PL/SQL
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 DetailsThe easiest way to use Java in Oracle
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 DetailsHow to get the contents of unknown SYS REFCURSOR
You can use the following procedure in order to get the unknown number of columns and column types.
More DetailsHow to open pluggable database automatically
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