Re: newbie question about data dictionary and views

From: Frank <fvanbortel_at_netscape.net>
Date: Sun, 13 Apr 2003 15:02:41 +0200
Message-ID: <3E995FF1.1080308@netscape.net>

kent wrote:
> I am a newbie to oracle database, i just can't remember the name of the data
> dictionary and views and their corresponding columns, so i can't rember
> their functions, is there any general rules for naming the dictionary and
> views?
>
>

All DBA_, USR_ and ALL_ views are plural, e.g. DBA_TABLES. All v$ stuff is not: e.g. v$datafile
That's all I know about "rules".

Some names are just plain ugly: dba_tab_columns; why not dba_table_columns - don't know...

-- 
Regards, Frank van Bortel

Received on Sun Apr 13 2003 - 08:02:41 CDT