How can i filter Table Synonyms with View Synonyms.
here is my code snippet which gets all Synonyms from Oracle Database.
String catalog=null;
String schema =mySchmea;
String tableNamePattern="%"
String[] types={"SYNONYMS"};
DatabaseMetaData dbData =referenced with my dbMetaData here.....
Resultset tablesResult = dbData .getTables(catalog, schema, tableNamePattern,types ) ;
This returns me all Synonyms created in the Schema.
Now i have to segregate TableSynonyms from ViewSynonyms.
Thanks