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 Aliases on Oracle 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 "Aliases on Oracle" Watch "Aliases on Oracle" New topic

Aliases on Oracle

Anthony Smith
Ranch Hand

Joined: Sep 10, 2001
Posts: 285
I kow how to create a synonym on a table name, but what can I do for a column? I am using an open source project that has a db schema meshed out and I did not want to change my code to reflect the column names nor do I want to chnage the open source columns to match my db. I have been successful with the synonyms for tables, but what can I do for columns?
[ April 15, 2004: Message edited by: Bear Bibeault ]
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Hi Tony,
You can redefine your column names in view definitions. That might help in this case. They might also help out 'changing' table names by the way, the advantage being that views are standard SQL, whereas synonyms are not (I think).
Good riding,
I agree. Here's the link:
subject: Aliases on Oracle
Similar Threads
Logging into Database
Resultset in Collections
What listener for JTable header column size change
how to make changes in the source xml doc
Good practice or not? Using DB Column name to map back to HTML & Java object names