Re: How to read table using Synonym

sunny076_at_yahoo.com wrote:
> Thank you for your reply. I want to get the metadata from the synonym.
> How can I do so? I was using the SQL syntax below to get Column name
> from Oracle Table.
> "select column_name, data_type, data_precision, data_scale
> from all_tab_columns"
>
> Thank you in advance,
>
> Sunny

SQL> create synonym t for test;

Synonym created.

SQL> select dbms_metadata.get_ddl('SYNONYM', 'T') from dual;

DBMS_METADATA.GET_DDL('SYNONYM','T')

   CREATE OR REPLACE SYNONYM "UWCLASS"."T" FOR "UWCLASS"."TEST" For more turn to Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)