Re: Another angle on this....

Here is my take on it, I am sure others can add more:

Tom McClelland wrote:

> Your points are valid, I don't contest them. However as someone coming
> from SQL Server to Oracle I have faced the following significant (to
> me) irritations:
>
> 1. Empty strings turned into nulls. Empty strings per se are not
> supported

I like nulls - seems the same as empty string to me.

>
> 3. No support for identity columns, instead requiring programmers to
> create sequences and triggers to achieve effects that are trivial in
> other databases

True. I found that DB2 uses sequences to accomplish identity columns (and that sequences are much harder to manage in DB2 than in Oracle).

>
> 4. No option to ignore case on indexes or character-string comparison

Have you looked at function based indexes? To_upper in where clause?

>
> 6. No support for "Case" notation

I thought this too --- but there is CASE now! I ran the same query in DB2 syntax on Oracle and it worked fine. Refer to SQL manual for this support.

>
Received on Mon Feb 18 2002 - 09:43:06 CST