Re: name of columns

From: Internet Station 1 <bob.smith_at_crownlift.com>
Date: 1997/09/12
Message-ID: <3419652F.2018@crownlift.com>#1/1

On the same note, try:

SELECT a.column_id, a.column_name
  FROM all_tab_columns a, user_synonyms b

  WHERE a.owner = b.table_owner
    AND a.table_name = b.table_name
    AND b.synonym_name = '<fill in you synonym name>'

  ORDER BY a.column_id;

Thanks,

Robert(Bob) Smith
bob.smith_at_crownlift.com

DISCLAIMER: The views expressed in this post are mine only and do not

            represent the views of Crown Equipment Corporation. Received on Fri Sep 12 1997 - 00:00:00 CDT