wood burning stoves 2.0*
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "segregating Table Synonyms with View Synonyms" Watch "segregating Table Synonyms with View Synonyms" New topic
Author

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.

Thanks


Sun Certified Java Programmer
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61106
    
  66

"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.

Thanks!
bear
Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
Don't get me started about those stupid light bulbs.
 
subject: segregating Table Synonyms with View Synonyms