Re: Differences between the Microsoft and the Oracle SQL server

Bob Poortinga wrote:
>
> ray charbonneau writes:
>
> > SQL capabilities in Oracle stored procedures are somewhat limited.
> > Last time I looked, you could not create temporary tables in a stored
> > procedure.
>
> If you really need to do this (which I doubt), use the DBMS_SQL package.
> Works like a charm.
>
> > You also could not join tables on Updates & Deletes.
>
> On which planet are you? On Earth, the following statement works just fine:
>
> update table1
> set attr1 = (select attr2 from table2
> where table2.key = table1.key);
>

[snip]

We use both Oracle and Sybase and I will have to say Oracles people and Tech support are unbearable.

Oracle is resource a hog ,yet very powerful

There are good 3rd party DBA tools for Sybase, better for MS sql and Oracles are clunk city.

SQL*net is a pain
If page level locking is so terrible how does sybase manage to support such large mission critical apps?

Or maybe they just say they do.

Denver,CO             
Internet                         jbuhl_at_den.mmc.com
phone                             (303) 977-8148
==============================