Multiple Value Reference
Hello,
I have a database that stores a location and its city - i.e.:
ThisPlace Sometown
I want to be able to better organize the data to allow for entries in the table to have multiple cities associated with them without entering a new record, i.e.:
ThisPlace Sometown
ThisPlace Thistown
ThisPlace Othertown
ThisPlace Somewhere
I want to be able to display all the names in the table without showing duplicates because cities are different. I'm looking for a way (possibly with another "cities" table) to store the cities and then reference them in this table. Thanks!
Subject
Views
Written By
Posted
Multiple Value Reference
3748
July 15, 2008 08:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.