Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: column prefixes
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
![]() |
![]() |