Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Aliases on Oracle

 
Anthony Smith
Ranch Hand
Posts: 285
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 54
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
Rudy
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic