Re: top 10 oracle quirks

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_at_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"