aspose file tools*
The moose likes JDBC and the fly likes segregating Table Synonyms with View Synonyms Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "segregating Table Synonyms with View Synonyms" Watch "segregating Table Synonyms with View Synonyms" New topic

segregating Table Synonyms with View Synonyms

Bhagya Tangutur
Ranch Hand

Joined: Oct 21, 2002
Posts: 88
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.


Sun Certified Java Programmer
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 61766

"Kumar BT",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Forum Bartender

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
subject: segregating Table Synonyms with View Synonyms