WITH clause and Depth First Search
In this article, I am going to explain how you can implement the depth first search with using the WITH clause or also known as subquery factoring clause. […]
More DetailsHow to reorder columns of table
If you want to change the order of the columns of any table without recreating it, then the following trick will work for you. Suppose you want to […]
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 Details5 Life Saving Features of Oracle
1) Partitioned Outer Join I would like to start with PARTITIONED OUTER JOIN. Because it is one of the least used feature. Suppose that you have two basic […]
More DetailsSQL Plan Baselines
SQL plan baseline is one of the most used tuning technique in Oracle database. Basically, with SQL plan baseline, you can change the execution plan of a sql […]
More DetailsHow to find the SQL_ID of your SQL statement
There are different ways to find the SQL_ID of an SQL statement. In this post, I am going to show two different ways of it. First, via dynamic […]
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 run external scripts from DBMS_SCHEDULER
In this post, I am going to explain how to run operating system level script files with using DBMS_SCHEDULER. All tests have been done in Oracle 19c. Generally, […]
More Details