Category
- AWS – Database (7)
- Helper SQL (16)
- Oracle 12c New Features (10)
- Oracle Internal (53)
- Oracle Performance (4)
- Oracle to (23)
- Oracle to PG migration (40)
- postgresql (25)
- SQL Developer (1)
- SQL Server Learning (22)
- SQLite Learning (1)
-
Join 97 other subscribers
Top Posts & Pages
- Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle.
- Conversion Chronicles - Invisible Indexes 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.
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
- Uncovering and Exploring ROW Constructors in PostgreSQL.
- Assignment feature with PostgreSQL 14 on Nested Array type
- Conversion Chronicles - Mapping Oracle Number Data types using AWS SCT and Ora2pg.
- Data Migration : Recreate Sequence in PostgreSQL from Oracle
- Convert the KEEP Clause in Dense_Rank\Rank Analytical from Oracle to PostgreSQL
Archives
- May 2024 (3)
- 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 Chronicles – Invisible Indexes in Oracle to PostgreSQL Migration. May 13, 2024
- Conversion Chronicles – Mapping Oracle Number Data types using AWS SCT and Ora2pg. May 9, 2024
- 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
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: database
Conversion Chronicles – Invisible Indexes in Oracle to PostgreSQL Migration.
Introduction – Invisible or Hidden Index. Any database conversion offers valuable insights into how things work across platforms or how to achieve similar functionality in the target database. Invisible indexes are one such feature that is often requested in PostgreSQL … Continue reading
Posted in Oracle to, Oracle to PG migration, postgresql
Tagged code conversion, database, hidden, hypopg, indexes, invisible, oracle, postgres, postgresql, SQL
Leave a comment
Conversion Chronicles – Mapping Oracle Number Data types using AWS SCT and Ora2pg.
Mapping Oracle Number Data types is crucial during migration, and AWS Schema Conversion Tool (SCT) and Ora2pg play vital roles. SCT offers precise mapping with custom transformations and constraint-based data type mapping. Ora2pg defaults to bigint for unassigned precision or scale and provides comprehensive configuration options, including custom script integration for automation. Continue reading
Posted in Oracle to PG migration, postgresql
Tagged aws sct, bigint, conversion, data type, database, double precision, number, numeric, ora2pg, oracle, postgres, postgresql, precision, programming, scale, SQL
Leave a comment
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, plpgsql, postgres, postgresql, SQL
Leave a comment
PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.
If you’re fascinated by the internals of PL/pgSQL processing and want to handle it efficiently, especially if you’re migrating procedural logic from another database, be sure to check out the previous posts in the series on PL/pgSQL Conversion Gotchas – … Continue reading
Posted in postgresql
Tagged conversion, database, development, migration, oracle, plpgsql, postgresql
Leave a comment
PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.
Databases Cursors are one of the key components of development. We have been using them for traversing query results for processing based on business logic or functionality. In Code Conversion, Cursor code always needs to be ported either from PL\SQL … Continue reading
Posted in Oracle to PG migration, postgresql
Tagged conversion, cursor, database, for loop, found, oracle, plpgsql, PLSQL, postgresql, programming
1 Comment
PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables.
Whether during conversions or new development, it’s essential to avoid variable names that could create ambiguity within functions or procedures.In the blog, we will walk through how to resolve variables conflicts within functions or procedures. Continue reading
Posted in Oracle to PG migration, postgresql
Tagged ambiguity, conversion, database, development, PL/pgSQL, postgres, postgresql, programming, SQL, variable
4 Comments
Why I Love psql – PostgreSQL Terminal.
At PGConf India 2024, I presented a well-received lightning talk on my love of using the psql terminal for PostgreSQL interaction, sharing valuable tips and tricks. The presentation slides, GIF animations, and additional references are available for those interested in delving deeper into psql. Visit the provided links for more details. Continue reading
Uncovering and Exploring ROW Constructors in PostgreSQL.
A ROW expression allows you to construct ROW values, which can represent anonymous records, specific table row types, or custom composite types. Its uses include processing records within multiple expressions (using operators like =, <>, <, <=, >, or >=), … Continue reading
Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle.
I would like to start the blog with an interesting fact: the language PL/pgSQL, which is used to build procedural code logic in PostgreSQL, is also an extension that is installed by default when you create a database. PostgreSQL is … Continue reading
Posted in Oracle to, Oracle to PG migration, postgresql
Tagged conversion, database, extension, migration, oracle, oracle-database, oracle_fdw, pg_cron, pg_hint_plan, pg_partm, pg_partman, pg_stat_statements, postgres, postgresql, SQL
1 Comment
Database and Migration Insights 