Hi Inosh, AFAIK Oracle limits column size to maximum of 30 characters. Since TABLE_NAME_COLUMN_NAME will not work in most cases. Thanks.
Regards, Prasad. On Tue, Nov 18, 2014 at 10:36 PM, Inosh Perera <[email protected]> wrote: > Hi all, > I went through couple of products and noticed, the naming conventions used > are inconsistent in some SQL scripts. > What is the standard way of naming, > 1. Tables - Currently, this is consistent, and the standard is appending a > prefix that describes to which component the table belongs to, such as > REG_*, UM_*. > 2. Columns - This is inconstant as some scripts contain > TABLE_NAME_COLUMN_NAME and some doesn't have the table name appended. I > also noticed some have COMPONENT_NAME_COLUMN_NAME, instead of table name > as a prefix. > > What is the recommend approach? > > Regards, > Inosh > > -- > Inosh Perera > Software Engineer, WSO2 Inc. > Tel: 0785293686 > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Prasad Tissera Software Engineer. Mobile : +94777223444
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
