Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.astraweb.com!news-small.astraweb.com!news-big.astraweb.com!207.217.77.102.MISMATCH!elnk-nf2-pas!newsfeed.earthlink.net!newshub.sdsu.edu!headwall.stanford.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: rgaffuri@cox.net (Ryan Gaffuri)
Newsgroups: comp.databases.oracle.misc
Subject: Re: top 10 oracle quirks
Date: 8 Aug 2003 05:22:47 -0700
Organization: http://groups.google.com/
Lines: 47
Message-ID: <1efdad5b.0308080422.2c3c1a65@posting.google.com>
References: <5370feb0.0308051514.63612234@posting.google.com> <3F311071.4A49DEE@remove_spam.peasland.com>
NNTP-Posting-Host: 198.80.171.28
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060345368 28995 127.0.0.1 (8 Aug 2003 12:22:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2003 12:22:48 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130367

Brian Peasland <dba@remove_spam.peasland.com> wrote in message news:<3F311071.4A49DEE@remove_spam.peasland.com>...
> My favorite quirk is when they don't use the same naming conventions in
> the DD views. For instance, in DBA_INDEXES, there is a column called
> OWNER. But in DBA_IND_COLUMNS it is INDEX_OWNER. All DBA_object (where
> object is something like TABLES, INDEXES, etc) there is an OWNER column,
> but in DBA_SEQUENCES it is SEQUENCE_OWNER. 
> 
> Cheers,
> Brian
> 
> 
> Aloha Kakuikanu wrote:
> > 
> > Here is my short list. Hope people would contribute
> > 
> > 1. O7_DICTIONARY_COMPATIBLITY
> > 
> > (somebody told me it's still there in 10i beta)
> > 
> > 2. VARCHAR2
> > 
> > the 2!
> > 
> > 3. _optimizer_undo_cost_change and _table_scan_cost_plus_one
> > 
> > can't decide which one is funnier
>  
> -- 
> ===================================================================
> 
> Brian Peasland
> dba@remove_spam.peasland.com
> 
> Remove the "remove_spam." from the email address to email me.
> 
> 
> "I can give it to you cheap, quick, and good. Now pick two out of
>  the three"


i hate that. different names for the same field in different data
dictionary views.

if you look at the forms demo you see 'when others then null' all over
the place and you should never use that. cant believe they put that
into a demo. other than the when others its a REALLY slick demo too.
lots of good reusable code.