The configuration of Oracle GoldenGate / Data Guard has the purpose of synchronizing data between two or more systems . The basic features of the…
View More Oracle GoldenGate vs Oracle Data Guard
Tag: oracle
Migration from Oracle to Postgres
Data Type Mapping PostgreSQL has rich set of data types. Some of the important Data type conversion between Oracle and PostgreSQL is as follow. Oracle…
View More Migration from Oracle to Postgres
Recursive Queries, CTE (Common Table Expression) or Self Join, Recursive Views
The CTEs are like temporary tables that exist only during the execution of the query. a simple example: Another example using a function Getting “manager tree” for…
View More Recursive Queries, CTE (Common Table Expression) or Self Join, Recursive Views
Display big numbers in SQLPLUS
NUMWIDTH setting which is by default 10 and hence you can display only 10 numbers without conversion but anything beyond that becomes exponential format. SHOW…
View More Display big numbers in SQLPLUS
Oracle database Patch on windows platform
Apply Oracle Patch on windows platform NOTE:412160.1 – Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches 1. Set…
View More Oracle database Patch on windows platform