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 96 other subscribers
Top Posts & Pages
- Why I Love psql - PostgreSQL Terminal.
- How to clear screen in PostgreSQL or psql terminal for Mac and Windows
- Conversion Chronicles - Invisible Indexes in Oracle to PostgreSQL Migration.
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
- Conversion Chronicles - Mapping Oracle Number Data types using AWS SCT and Ora2pg.
- Change Date in Oracle using FIXED_DATE
- Oracle internal view options with PostgreSQL Compatible.
- Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL
- About me
- Export Table to S3 in Amazon Aurora PostgreSQL on Migrating away from Oracle using UTL_FILE.
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: Top
#SQLSERVERLearning : Order By Learning.
Most of folks feel , both(Oracle-SQLServer) are traditional RDBMS database and should or need to work some what “SIMILAR”. But, But when we actually start working on core with queries, development and tuning.We identified a lot of difference between any … Continue reading
Posted in SQL Server Learning
Tagged Distinct, inline views, order by, sql server, Top, XML Path
1 Comment
Database and Migration Insights 