Concurrency Control is a mechanism that maintains consistency and isolation, which are two properties of the ACID, when several transactions run concurrently in the database.…
View More Concurrency Control
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
Statistics History restore table old stats in Oracle
Restore old table statistics in Oracle Check and Restore the old statistics of tables in OracleOracle Stats will help the optimizer to choose better execution…
View More Statistics History restore table old stats in Oracle