Hello,

i am working with Oracle 9i on a project where the TABLEs and COLUMNs
conform to some standard, which, IMO, makes the names too tedious to
use in ad hoc queries. To ease use, i CREATEd a SYNONYM for each
TABLE, and i am happier with it now.

I would like to do the same thing to the COLUMN names (remove the
project/table prefix, add in vowels, correct typos, etc...), but there
are no SYNONYMs for COLUMN names. So, i was thinking of DROPping the
SYNONYM idea, and just renaming both TABLEs and COLUMNs in a new VIEW
for each TABLE.

I have two questions. One, will using a VIEW (straightforward select
col_1, col_2, ..col_n from table) be inefficent, or is it the same as
querying the TABLE directly? Two, is there something for a COLUMN like
SYNONYM if for a TABLE?

B.

Brian Tkatch wrote:
Only with a view and the efficiency is something you need to test
with your queries using your hardware with your application data.
Likely it will be small enough to be ignored.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org