Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: column prefixes

Re: column prefixes

From: Phouka <phouka_at_frii.com>
Date: 1998/02/20
Message-ID: <34EDECAF.6D76@frii.com>#1/1

suhasu_at_hotmail.com wrote:  

> Are there any pros/cons to having table identifying
> prefixes to column names???

As a developer, I must say that I *hate* it. It means that I have fewer options to write generic code, and it always seemed overkill to me.

If I want to fully qualify name (which I should in select statements) then I'll use the table(alias).column notation, which is much clearer.

Plus, it's more typing, and can be confusing if there are similiar table names.

Robin
phouka_at_frii.com Received on Fri Feb 20 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US