Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Comparison of Oracle commans Vs. SQL Server Commands

Re: Comparison of Oracle commans Vs. SQL Server Commands

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 31 May 2007 11:09:14 -0700
Message-ID: <1180634953.355360@bubbleator.drizzle.com>


Serge Rielau wrote:
> 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

I had considered this except that assemblies are not truly equivalent structures: Not like tables and indexes and functions where comparable objects exist in multiple products. I think of them as equivalent to Oracle libraries.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_6001.htm#SQLRF01301

Assemblies do not have:

1. Session global variables and types
2. Variables that persist for term of session
3. An Initialization section
4. Overloading

Calling them equivalent to packages it seems to me would be more misleading than not.

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

-- 
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 - 13:09:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US