File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 63548

"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] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: segregating Table Synonyms with View Synonyms
It's not a secret anymore!