Category
- AWS – Database (7)
- Helper SQL (16)
- Oracle 12c New Features (10)
- Oracle Internal (53)
- Oracle Performance (4)
- Oracle to (20)
- Oracle to PG migration (32)
- postgresql (14)
- SQL Developer (1)
- SQL Server Learning (22)
- SQLite Learning (1)
-
Join 57 other subscribers
-
Top Posts & Pages
- Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL
- How to Connect to Oracle Database Through SSH Tunnel Using SQL Developer.
- How to Clear the Screen in psql for Mac and Windows
- SUBSTR Functionality Differences Between Oracle and PostgreSQL: What You Need to Know
- Subtle Art of Code Conversion in Oracle to PostgreSQL Migration.
- How to Convert the KEEP Clause in Analytical Functions from Oracle to PostgreSQL
- How to Handle No Data Found with Scalar function in Oracle to PostgreSQL Migration.
- How to Filtered records on loading data from Amazon S3 to RDS for PostgreSQL
- Unleasing Boolean data type casting in PostgreSQL.
- Data Dictionary - user_constraints/user_cons_columns is slow in Oracle 12cR1
Archives
- 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 (2)
- 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
- 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
- SUBSTR Functionality Differences Between Oracle and PostgreSQL: What You Need to Know January 9, 2023
- Unleasing Boolean data type casting in PostgreSQL. January 8, 2023
- Navigating Aliases in Oracle to PostgreSQL Migrations January 6, 2023
- PostgreSQL 15 – Interesting feature with View having security invoker option. November 2, 2022
- Assignment feature with PostgreSQL 14 on Nested Array type July 19, 2022
- Oracle internal view options with PostgreSQL Compatible. January 8, 2022
- Uncovering the Mystery of Comparing NULL Data in PostgreSQL December 12, 2021
- Interesting PSQL features from PostgreSQL releases you don’t wanna miss. December 5, 2021
Blogs I Follow
- 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
- Viswamitra's blog
- 0BAD-C0DE
- bdt's blog
- Data Warehousing with Oracle
- JingsBlog
- SQL Undercover
- Smart way of Technology
- Shraddha's Blog
- Hypnagogic Hallucinations
- SQL with Manoj
- 🛩️ Shane Borden's Technology Blog
- seanstuber
Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL
Posted in Oracle to PG migration, postgresql
Tagged analytical, Count, Distinct, Oracle, postgresql, window, window function
Comments Off on Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL
Subtle Art of Code Conversion in Oracle to PostgreSQL Migration.
This post is for subscribers
Posted in Oracle to PG migration, postgresql
Tagged code conversion, migration, Oracle, postgresql
2 Comments
Maximizing PostgreSQL’s Charms: A Pattern for Indexes and Skewness When Migrating from Oracle
This post is for subscribers
Posted in Oracle to PG migration, postgresql
Tagged histogram, migration, Oracle, partial index, postgresql, skew
Comments Off on Maximizing PostgreSQL’s Charms: A Pattern for Indexes and Skewness When Migrating from Oracle
Get the most out of PostgreSQL using psql with must known features.
This post is for subscribers
Posted in postgresql
Tagged password, postgresql, psql, tips, tricks, \ef, \gexec, \watch
Comments Off on Get the most out of PostgreSQL using psql with must known features.
SUBSTR Functionality Differences Between Oracle and PostgreSQL: What You Need to Know
This post is for subscribers
Posted in Oracle Internal, Oracle to, Oracle to PG migration, postgresql
Tagged Oracle, orafce, postgres, postgresql, Substr
2 Comments
Unleasing Boolean data type casting in PostgreSQL.
This post is for subscribers
Posted in Oracle to, Oracle to PG migration, postgresql
Tagged boolean, casting, character, implicit, migration, ora2pg, Oracle
Comments Off on Unleasing Boolean data type casting in PostgreSQL.
Navigating Aliases in Oracle to PostgreSQL Migrations
This post is for subscribers
Posted in Oracle to, Oracle to PG migration, postgresql
Tagged alias, difference, from, ORA-00933, Oracle, postgresql, subquery
Comments Off on Navigating Aliases in Oracle to PostgreSQL Migrations
PostgreSQL 15 – Interesting feature with View having security invoker option.
This post is for subscribers
Posted in Oracle to PG migration, postgresql
Tagged definer, invoker, latest, postgresql, postgreSQL 15, security, view
Comments Off on PostgreSQL 15 – Interesting feature with View having security invoker option.
Assignment feature with PostgreSQL 14 on Nested Array type
This post is for subscribers
Posted in Oracle Internal
Tagged array, assignment, collection, migration, Oracle, postgresql, postgresql 14
Comments Off on Assignment feature with PostgreSQL 14 on Nested Array type
Oracle internal view options with PostgreSQL Compatible.
This post is for subscribers
Posted in Oracle to, Oracle to PG migration
Tagged internal, Oracle, postgresql, views
Comments Off on Oracle internal view options with PostgreSQL Compatible.
Database and Migration Insights 