Re: Comparison of Oracle commans Vs. SQL Server Commands

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 31 May 2007 17:57:34 -0700
Message-ID: <1180659453.76120@bubbleator.drizzle.com>

Serge Rielau wrote:
> DA Morgan wrote:

>> I'd be interested in the opinions of others ... especially those who
>> have actual working experience with Oracle which, alas, Serge does not.

> Preferably from those who have used assemblies as well.
>
> I'd be careful about being too picky.
> Oracle routines have no overloading outside of packages.

Provided one ignores type bodies which also support overloading. And, in a sense, user defined operators, which also constitute a form of overloading.

Perhaps this will help:
http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14260/adobjadv.htm#sthref932 http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6004.htm#SQLRF01304

> Doesn't look to good compared to IDS or DB2.

I have not put together web pages on either. With IDS and Sybase because the marketshare is insignificant. With DB2 because I can't figure out how to represent your three different code bases.

> But hey, you pick what counts. ;-)

My website ... so yes I do. <g>

BTW: Having different definitions within a "single product" for how many bytes to a column name is also a form of overloading. But not one I'd want to emulate. <g>

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu May 31 2007 - 19:57:34 CDT