Spreading Knowledge
In my day-to-day work, Oracle is the main DBMS I use. Over time, I’ve come to really appreciate one particular feature—especially when things go wrong. It’s called Flashback, and it’s saved me from panic more times than I’d like to admit. I’m not sure if other DBMS platforms have something similar, but in this post, … Read more
In this post, we’ll walk through how to build a simple yet robust RESTful API using ASP.NET Core and Oracle Autonomous Database. We’ll integrate Dapper for lightweight ORM functionality and demonstrate how to execute Oracle stored procedures efficiently. Development Environment Oracle Autonomous Database : https://www.oracle.com/autonomous-database/Dapper: https://www.learndapper.com Step 0: Create the Project for .NET Core Web … Read more
While working with Oracle Autonomous Database in Oracle Cloud, I hit a roadblock trying to do something that seemed pretty basic: creating a tablespace. This is something I’ve done before in AWS RDS for Oracle without any issues, so I assumed it would work the same way here. Well… it didn’t. 😅 🤔 What I … Read more