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 DetailsIn 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 DetailsIn 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 DetailsLet’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 DetailsAs 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 DetailsIn 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 DetailsException 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 DetailsIf 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 DetailsThere 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 DetailsYou can use the following procedure in order to get the unknown number of columns and column types.
More DetailsThere 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