Guy,
I have seen people using:
Name_SEQ for sequences;
Name_IDX for indexes;
Primary key columns are (ID) and foreign keys columns
(referenced_table_name_ID);
Primary key constraints - (table_name_PK)
Unique key constraints - (table_name_UK)
Foreigh key constraints - (table_name_FK)
For table columns use if possible full column description (no abreviations)
Hope that helps.
Trifon Anguelov
Senior Oracle DBA
http://www.dbaclick.com
"Guy Dillen" <gdi_at_belgacom.net> wrote in message
news:3c2b9432$0$33504$ba620e4c_at_news.skynet.be...
> Are there any naming conventions for Oracle
> database objects (table names, column names, indexes, keys, stored
> procedures, ...)
>
> All input very much appreciated.
>
> Thanks.
>
> Guy
>
>
>
- WAS CANCELLED BY =======:
Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: "Trifon Anguelov" <trifona_at_pacbell.net>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <ZAdX7.17090$HH6.3934416094_at_newssvr14.news.prodigy.com>
Control: cancel <ZAdX7.17090$HH6.3934416094_at_newssvr14.news.prodigy.com>
Date: Mon, 31 Dec 2001 06:41:02 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.ZAdX7.17090$HH6.3934416094_at_newssvr14.news.prodigy.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009788953 26548 166.102.15.34 (31 Dec 2001 08:55:53 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 08:55:53 GMT
X-Auth-User: 057276600/9d71d23ddb8d15f2
X-Post-Time: Mon, 31 Dec 2001 08:02:21 GMT
X-Problems-To: abuse_at_prodigy.com
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes
<remainder snipped>
Received on Sat Dec 29 2001 - 00:42:01 CST