Wed, 06 Dec 2000 13:52:05 +0100 Anton Dischner <dischner_at_klch.med.uni-muenchen.de> wrote:
> 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?
>
I am not sure if there is any handy tool like decode in SQL-Server 4.x
--
e-Consultant
http://www.asl.com.hk/employment.htm
http://www.eroom.com
Received on Wed Dec 06 2000 - 09:30:23 CST
