Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VIEWS or SYNONYM's

380441Jun 10 2004 — edited Jun 11 2004
Dear List,

I have a simple TABLE called country (ID_COUNTRY, ENGLISH, GERMAN, FRENCH)

The first 2 rows could be.

INSERT INTO COUNTRY(...) (1, 'Germany', 'Deutschland', 'Allemagne');
(2, 'Great Britain', 'Großbritannien', 'Grande-Bretagne');


I would like to create an object, available for users outside our app., where ID_COUNTRY =1 always is shown for example as "DE", which is the ISO 3166-1 country code. I am not sure, but I guess I could use a SYNONYM and a VIEW combined ?

This would mean we would not need to change our database schema, but it would make us sort of ISO compatible ;)

I hope someone can help,

Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2004
Added on Jun 10 2004
10 comments
272 views