When you develop an application that uses a database, one of the topics you need to consider is how to connect to the database. Some application use a one-to-one connection,
Category: Database Development
DB Comparison Project: Working with DatesDB Comparison Project: Working with Dates
As I started this project, I prepared a list of topics for my posts. One of them was “working with different data types” as there are differences between the different
DB Comparison Project: Pseudo ColumnsDB Comparison Project: Pseudo Columns
This is the third post in this project, where I compare 4 major databases: Oracle, SQL Server, PostgreSQL, and MariaDB, and this time I’ll talk about pseudo columns (or system
DB Comparison Project: Handling TransactionsDB Comparison Project: Handling Transactions
Before I start I just wanted to remind that this is one part of a series about comparing the basic functionality of four different RDBMS: SQL Server, Oracle, MariaDB, and
DB Comparison Project: Using NULLsDB Comparison Project: Using NULLs
I decided to start a comparison between four main databases from a development perspective. If you want to read more about it, I introduced the project here. And for the
DB Comparison Project for Developers (mainly)DB Comparison Project for Developers (mainly)
I’ve decided to start an interesting project. I have no idea how long it will be or how many topics I’ll decide to research, but I have at least a
Checking SQL Progress in OracleChecking SQL Progress in Oracle
Checking an SQL statement progress is never easy. There are so many parameters that affect your execution time and estimates are never correct. So in this post I’ll mention a
ORA-30481 After Upgrading to 19cORA-30481 After Upgrading to 19c
Lately I’m in the process of upgrading a few clients to 18c and 19c, so I expected to hit a few issues. In this post I’ll discuss a specific issue
ORA-29283 with UTL_FILE in Oracle RACORA-29283 with UTL_FILE in Oracle RAC
UTL_FILE is used to work with local files on the database server side. In this post I’ll explain why you might get ORA-29283 in RAC (but not only) and how
High CPU With Queries Without Bind VariablesHigh CPU With Queries Without Bind Variables
Performance problems can be tricky, and everyone has a different method to approach them depending on the exact issue. In this case I’d like to cover a specific case of