A Simple SQL Query for ALL_SYNONYMS

 Hi All,

 I have the following scenario

 create table t1 ( col1 varchar(10) );

 create synonym S1 for T1;
 create synonym S2 for S1;
 create synonym S3 for S2;
 create synonym S4 for S3;

 Select synonym_name , table_name from all_synonyms where owner ='SCOTT' returns the following
 S1 T1
 S2 S1
 S3 S2
 S4 S3

 wherein i want the following output to be generated.  S1 T1
 S2 T1
 S3 T1
 S4 T1

 So without creating a temporary table, how can i achieve this. Any help regarding this will be highly appreciated

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 21:58:58 CDT