Re: Differences between Oracle RDBMS and MS SQL Server

Hi,

> - AFAIK, Oracle has no equivalent to SQL server's "top n" in select clause
> (rownum comparisons don't count)

What's wron with 'select * from big_query where rownum <= 100;' ?

> - Oracle doesn't have bitwise operations like SQL server

There's bitand defined in sys.standard.
It's not documented but used by the system.

> - Oracle doesn't support "x=y" column aliasing ("y as x" is harder
> to read, IMO)
>

So use 'select bla_ggg_name name, bla_ggg_dfgdfg shortname from my_table' ;-)

> I like the feature of SQLServer that we can use "= null" or "is null"

You can do this in Oracle too, with different results ;-)

> fine time granularity

try 'select * from v$timer'

Is there an equivalent to julian date in SQL-Server? Is there a handy tool like decode in SQL-Server?

Done,

Toni

-- 
ZXR750H, 55 Mm. 
Q: How did the medical community come up with the term "PMS"?
A: "Mad Cow Disease" was already taken.
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner