Simply pass your religion & nationality to this function to get the politically correct greeting from me. :)
create or replace function HappyHolidays
(p_religion in varchar2, p_nationality in varchar2)
return varchar2
is
l_result varchar2(255);
begin
if p_religion like '%christianity%' then
l_result := 'Merry Christmas';
elsif p_religion like '%jewish%' then
l_result := 'Happy Hanukkah';
elsif p_religion like '%pagan%' then
l_result := 'Happy Winter Solstice';
else
l_result := 'Seasons Greetings';
end if;
if p_nationality != 'Chinese' then
l_result := l_result || ' and Happy New Year';
end if;
return l_result;
end HappyHolidays;
/
Comments
Happy Holidays to you too!
create or replace function JoyeuseFetes
(p_religion in varchar2, p_nationalité in varchar2)
return varchar2
is
l_result varchar2(255);
begin
if p_religion like '%chrétienne%' then
l_result := 'Joyeux Noel';
elsif p_religion like '%juive%' then
l_result := 'Joyeuse Hanukkah';
elsif p_religion like '%païenne%' then
l_result := 'Joyeux solstice d’hiver';
else
l_result := 'Joyeuses Fêtes';
end if;
if p_nationalité != 'Chinoise' then
l_result := l_result || ' et Bonne Année';
end if;
return l_result;
end;
/
What about pagans down under where we've just had the summer, not winter, solstice ?
But at least you managed to arrange the celtic looking word verification of
lldsunej
The code provided is done as "as is". No guarantees - implicit or otherwise - are included. Use it at your own risk. :)
- Scott -
"PENANG: Today, the Chinese celebrate Dong Zhi or the Winter Solstice Festival, marking “the arrival of winter”. "
http://www.thestar.com.my/news/story.asp?file=/2005/12/22/nation/12933828&sec=nation
At 30 Degrees Celsius, the is nothing cold about Winter in Malaysia, except in Air-Conditioned enviroments...
Anyhow, their (lunar) new year is only weeks away at the end of January...
Christianity
Judaism
Paganism
Happy holidays!!!
WV: etnth - "Eatin the???"