How 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 DetailsCategory: PL/SQL
The 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 DetailsHow to create a temporary job
Basically, you can create a single scheduler job by the following syntax. This job executes and drops itself automatically. If your procedure that used in the scheduler job […]
More DetailsSUBSTR vs DBMS_LOB.SUBSTR
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 DetailsParallel Enabled Pipelined Table Functions
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 DetailsPipelined Table Functions
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 DetailsData encryption and decryption using PL/SQL
Data encryption is the one of the key feature for security. It can be used for several purposes. I used DBMS_CRYPTO package for this. DBMS_CRYPTO.ENCRYPT function requires the […]
More Details