Nothing to do with requirements for Oracle. It was my boss' requirement to make my sql statement shorter<g>. I think their because with large systems, it's easy to get knarly sql statements, they've developed a standard of apprevating where they can.

PF

>Perry,
>
>What was/is the reason for one letter alsias requirement in Oracle? There isn't such requirement for SQL Server.
>
>>I know Mark does a lot with Oracle. I assume he's experienced what I did. When I worked with Oracle, it was required of me to use short, if not 1 char, aliases. I haven't worked enough with folks in a big SQL Server shop to see if they do the same.
>>
>>>Aliasing tableas to one letter names is the same bad idea as usindg one letter variables. It makes code unreadable and hard to maintain.