Differences between DB2 and Oracle

database oracle db2
Ondrej Slinták picture Ondrej Slinták · May 19, 2010 · Viewed 23.8k times · Source

We had a talk with colleagues about databases yesterday as we will have a DB2 education in few weeks. I'm wondering, what are the differences between DB2 and Oracle as two major enterprise solutions? Are there any limitations in comparison to each other? Are there any tasks more suitable for DB2 or Oracle?

(I found this article, but I somehow doubt it covers everything)

Answer

paxdiablo picture paxdiablo · May 19, 2010

The major difference in my eyes is that DB2 can tell the difference between a NULL and an empty string :-)

Related questions

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such …

Read More
DB2 database in Oracle SQL developer

I've heard it's possible to connect to a mainframe DB2 database with a client like Oracle SQL developer. I've looked on-line and can't seem to find the connector files needed to do this in SQL developer. Can anyone direct me …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More