Re: Comparison of Oracle commans Vs. SQL Server Commands

DA Morgan wrote:
> Are you saying you are incapable of pointing out a single error or
> omission from my website? You first! <g>
Oh for crying out loud...
1. The equivalent to a PACKAGE is an ASSEMBLY 2. SQL Server doesn't have global temps, they have "merely" temps, but temps aren't needed in Oracle because of MvCC.... Why does Oracle have Global Temps? I got lost in the logic...Funny how associative arrays and index by tables aren't temps... BULK COLLECT and FORALL is all about filling and draining PL/SQL temps
3. SQL Server supports recursive common table expressions as equivalent to connect by.
4. You state SQL Server supports only limited synonyms. The only thing I'm seeing as missing are object types (well, now) 5. You claim Oracle can do user defined types for MONEY etc. I'd like to see that. Are you saying object types? Because AFAIK there are no DISTINCT types in Oracle outside of PL/SQL (subtype) 5. By the same token you do not grant SQL Server that it can use user defined types for the Oracle types.
6. Something fishy about the date time arithmetic. JUst because functions aren't named the same doesn't mean they don't exist. But I'm not going to do other people's work ;-)
7. For long type SQL Server uses "max" notation: VARCHAR(max) etc...

Well I'm no SQL Server expert, but it's a start.

Cheers
Serge

PS: It is interesting to see how they have side stepped the whole OO and package issue with CLR and ASSEMBLY.

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab