How to generate, parse and use JSON data
In this article, I will explain how easily you can generate, parse and use JSON data in the Oracle database. I used Oracle 19c for all examples in […]
More DetailsHow to flush a cursor from the shared pool
If you want to remove any cursor in the shared pool. You can do it easily via sys.DBMS_SHARED_POOL .PURGE procedure. 1. Get the address and hash_value of the […]
More DetailsHow to view alert log file
First of all, in order to find your log files location in the operating system where the database is located, you can query to V$DIAG_INFO view. It contains […]
More DetailsUseful Oracle Functions
How to find the difference between two dates If you want to find the difference between two dates according to different time types, you can use the EXTRACT […]
More DetailsHow to unregister materialized view from source DB
If a remote MV is no longer available or if you move to a new server because of data migration, version upgrade etc. and somehow don’t need the […]
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 DetailsWe have been awarded Top 100 Oracle Blog
Hello All, we have been awarded Top 100 Oracle Blog by feedspot. I really would like to thank to feedspot team. There are very valuable blog writters in […]
More DetailsHow to use Flashback
Flashback feature is available only for enterprise edition. In this article, Oracle 19c has been used for all examples. With flashback feature you can recover your table or […]
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 Details