SQL & PL/SQL

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