Re: Oracle8i and nullif

"Ralph" <nurfuerschrott_at_gmx.de> a écrit dans le message de news: 1128522631.634681.321940_at_g43g2000cwa.googlegroups.com...
| Hi @ll,
|
| is there anything like the nullif-function in oracle8i ? It can be a
| more complex construction, the only need is, that it can be used in the
| fieldlist.
|
| select
| number,nvl2(nullif(to_char(birthday,'YYYY'),to_char(welcomedat,'YYYY')),'Yes','No')
| from customer
|
| This works fine in 9i (not regarding the senseless columns) but I can't
| find anything similar in 8i...
|
| Any ideas?
|
| Greets Ralph
|

decode (to_char(birthday,'YYYY'), to_char(welcomedat,'YYYY'), NULL , to_char(birthday,'YYYY'))

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/expressi.htm#1016155

Regards
Michel Cadot Received on Wed Oct 05 2005 - 09:43:17 CDT