Category
- AWS – Database (7)
- Helper SQL (16)
- Oracle 12c New Features (10)
- Oracle Internal (53)
- Oracle Performance (4)
- Oracle to (22)
- Oracle to PG migration (38)
- postgresql (23)
- SQL Developer (1)
- SQL Server Learning (22)
- SQLite Learning (1)
-
Join 91 other subscribers
Top Posts & Pages
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
- How to clear screen in PostgreSQL or psql terminal for Mac and Windows
- How to Connect to Oracle Database Through SSH Tunnel Using SQL Developer.
- PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.
- AWS Blogs
- Change Date in Oracle using FIXED_DATE
- Oracle internal view options with PostgreSQL Compatible.
- Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle.
- The Differences Between the SUBSTR Functions in Oracle and PostgreSQL: What You Need to Know
- Load and Filter records using aws_s3.table_import_from_s3 from S3 to RDS for PostgreSQL
Archives
- May 2024 (1)
- April 2024 (3)
- March 2024 (1)
- February 2024 (1)
- December 2023 (1)
- October 2023 (1)
- June 2023 (1)
- May 2023 (1)
- April 2023 (1)
- February 2023 (1)
- January 2023 (3)
- November 2022 (1)
- July 2022 (1)
- January 2022 (1)
- December 2021 (2)
- November 2021 (1)
- September 2021 (3)
- August 2021 (1)
- May 2021 (1)
- May 2020 (2)
- April 2020 (7)
- February 2020 (1)
- December 2019 (1)
- November 2019 (5)
- October 2019 (4)
- September 2019 (3)
- August 2019 (2)
- March 2019 (2)
- January 2019 (2)
- September 2018 (2)
- April 2018 (1)
- June 2017 (1)
- May 2017 (3)
- April 2017 (4)
- March 2017 (1)
- January 2017 (3)
- December 2016 (10)
- November 2016 (6)
- October 2016 (1)
- August 2016 (1)
- June 2016 (2)
- May 2016 (1)
- February 2016 (1)
- January 2016 (1)
- November 2015 (3)
- September 2015 (1)
- April 2015 (1)
- January 2015 (2)
- December 2014 (5)
- November 2014 (11)
- April 2014 (2)
- March 2014 (1)
-
Recent Posts
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration May 3, 2024
- PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type. April 23, 2024
- PL/pgSQL Conversion Gotchas: Cursors and Last Fetch. April 12, 2024
- PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables. April 10, 2024
- Why I Love psql – PostgreSQL Terminal. March 5, 2024
- Uncovering and Exploring ROW Constructors in PostgreSQL. February 27, 2024
- Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle. December 16, 2023
- PostgreSQL 16 Feature : Sub-Query Aliases and its usage in Code Conversion. October 2, 2023
- Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL June 2, 2023
- Subtle Art of Code Conversion in Oracle to PostgreSQL Migration. May 13, 2023
- Maximizing PostgreSQL’s Charms: A Pattern for Indexes and Skewness When Migrating from Oracle April 2, 2023
- Get the most out of PostgreSQL using psql with must known features. February 14, 2023
Blogs I Follow
- My Big Data World
- kossip - by the people behind Ameyo: On technology and beyond
- Talk Tech With Sonakshi :)
- Learn. Share. Repeat.
- Ardent Performance Computing
- PgCraftsman
- Nivlesh's Blog
- SQL coding questions
- Database Technologies & Cyber Security Platform
- Oguri's blog
- 0BAD-C0DE
- bdt's blog
- Data Warehousing with Oracle
- JingsBlog
- SQL Undercover
- Shraddha's Blog
- Hypnagogic Hallucinations
- SQL with Manoj
- 🛩️ Shane Borden's Technology Blog
- seanstuber
Tag Archives: implicit conversion
Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
Introduction – Implicit Conversion Oracle to PostgreSQL migration is a playground that uncovers and touches upon many database concepts, which are always intriguing and fun to explore. Implicit Conversion, i.e., imposing automatic conversion on data types to make them comparable … Continue reading
Posted in Oracle to PG migration, postgresql
Tagged database, error, implicit conversion, migration, operator, Oracle, postgres, postgresql, SQL
Leave a comment
Numeric types and implicit conversion in PostgreSQL
PostgreSQL offers enriching variant for storing numeric kind of data. it varies from being integer types , floating type or as Numeric. it’s always wise to understand on how it internally execute for equality operator when we try to compare … Continue reading
Posted in Oracle to PG migration
Tagged implicit conversion, numeric, performance, postgresql
Leave a comment
Implicit Conversion consideration while migration from Oracle to PostgreSQL.
Implicit Conversion most of time hides anomalies of inconsistent datatype.Oracle support implicit conversion when comparing Different kind of DataType in a Query. Its naturally a bad design, as a Database Developer we should have Table schema and Filter bind of … Continue reading
Posted in AWS - Database, Oracle Internal, Oracle to PG migration
Tagged aws, implicit conversion, Oracle, postgresql
Leave a comment
Explain plan Command : Why we should not rely for exact runtime plan.
For getting SQL plan we have lot of method in oracle, one of them being EXPLAIN PLAN FOR Command.We use EXPLAIN PLAN Command to get estimated Plan without running the SQL. Oracle perform parsing on SQL and store estimated plan … Continue reading
Posted in Oracle Internal
Tagged Explain plan, Explain plan for, histogram, implicit conversion, Oracle
5 Comments
Database and Migration Insights 