Recent posts

Internals of SYSDATE and Date Comparisons in Oracle

Internals of SYSDATE and Date Comparisons in Oracle 1.  What is SYSDATE ? SYSDATE retur…

Read more

Convert Oracle Timestamp to SCN and SCN to timestamp

Find Convert Oracle Timestamp to SCN and SCN to timestamp How to get current SCN SELECT T…

Read more

Step-by-step guide to create a database link from Oracle to Microsoft SQL Server

Step-by-step guide to create a database link from Oracle to Microsoft SQL Server Guide t…

Read more

Fixing ORA-28500 With DG4ODBC: Strange Bracket Symbol When Connecting to Non-Oracle Databases

Fixing ORA-28500 With DG4ODBC: Strange Bracket Symbol When Connecting to Non-Oracle Datab…

Read more

PROD Hot Oracle Database Cloning Without RMAN

PROD Hot Oracle Database Cloning Without RMAN Hot database cloning is ideal for 24/7 pro…

Read more

How to Safely Remove an Oracle ACFS File System and ASM Volume

How to Safely Remove an Oracle ACFS File System and ASM Volume If you no longer need an O…

Read more