| 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: 56150
|
|
"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
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
|
 |
 |
|
|
subject: segregating Table Synonyms with View Synonyms
|
|
|