Multi-language in one Database

Hi,

Is there in Oracle any native support of multi-language : With a same SQL query, I would like to retrieve the same data in a given language just by defining a language variable (or something like that) ? for exemple : with LANG = EN, my SELECT returns the english version of my data, with LANG = FR, it returns the french version.

If no such mecanism exists, do you have any suggestion on the best solution ? (one column per language ? on table per language ? use of a same view on front of tables for switching between language (how about updating in this case )?)

Thanks in advance.

-- 
z.wang_at_sysium.com