Re: sql loader data conversion

From: Mike Krolewski <mkrolewski_at_rii.com>
Date: Mon, 18 Dec 2000 23:34:24 GMT
Message-ID: <91m6u0$jpu$1@nnrp1.deja.com>

In article <91lmea$3rq$1_at_nnrp1.deja.com>, mdoherty_at_atroad.com wrote:
> Need to know how to convert column value from True to = 1 and if False
> to = 0
>
> Sent via Deja.com
> http://www.deja.com/
>

Look into SQL Phrases in the SQL Loader MANUALS!!!

field1 <position information> <datatype> " decode (:field1, 'True',1,'False', 0, 0) "

Note the colon is important.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/

Received on Mon Dec 18 2000 - 17:34:24 CST