Re: The reserved word "ACCESS" in a field list of a PL SQL Query

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 13 Sep 2004 02:48:13 GMT
Message-ID: <NT71d.201284$X12.170769@edtnps84>

Lee wrote:

> In defense of the column ('field') named "Access" this came over from
> the conversion of the MS Sql db that we are in the process of porting.

You make use of the term 'porting'. Does that imply you are using an intelligent analysis to translate the functionality from one environment, or does that mean you are simply defaulting to "copy everything across - it's SQL, isn't it?"

If you are truly doing an intelligent port, renaming the column to avoid the reserved word issue is going to be a small thing.

If, on the other hand, you are assuming that SQL Server and Oracle work the same because they both [supposedly] implement SQL, you may be in for a surprise. *That surprise is well documented throughout Thomas Kyte's 'Effective Oracle By Design'* (Hint: first symptoms usually include max'ing out at 3-5 users or significant performance issues, or deadlocks.)

/Hans Received on Sun Sep 12 2004 - 21:48:13 CDT