This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 60794
    
  65

"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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: segregating Table Synonyms with View Synonyms
 
Similar Threads
getTables schema question
Want to get table names from db in access
table list
How to get table names ?
To get Database tables