Interesting that NULLIF exists only in SQL*LOADER...I wonder why? But
decode is actually more powerful since you can get any value returned based
on how an expression evaluates, not just NULL.
--
Regards,
Jim
<michael_bialik_at_my-deja.com> wrote in message
news:7mnclo$fek$1_at_nnrp1.deja.com...
| Hi,
|
| There is the same NULLIF used in Oracle SQL*Loader
| utility. It works the same way as in DB2 :
|
| LOAD DATA INFILE 'xxx.dat'
| INSERT INTO TABLE emp (
| empno position(01:04) INTEGER NULLIF empno=BLANKS,
| ename POSITION(05:15) CHAR ...
|
| Regards. Michael.
| In article <7mm0pa$esm$1_at_news.btv.ibm.com>,
| "Jim Morgan" <jjmorgan_at_us.ibm.com> wrote:
| > Anyone know if there is an Oracle equivalent to this DB2 function?
| Thanks!
| >
| > --
| > Regards,
| > Jim
| >
| >
|
|
| Sent via Deja.com http://www.deja.com/
| Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 09:15:20 CDT
