Re: Need help with SQL*Loader.

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 5 Aug 1998 06:19:42 +0200
Message-ID: <6q8mg3$8iu$1_at_pascal.a2000.nl>

Maybe:

my_date pos 010:017 date 'YYYYMMDD'

      nullif blanks
      " decode( my_date, '00000000', null) "

You can put any additional SQL statement in the double quotes. I am not sure if SQL*Loader executes it prior to converting it to a date...

Arjan. Received on Wed Aug 05 1998 - 06:19:42 CEST

This message: [ Message body ]
Next message: Eduardo verdia: "Re: BIG Designer 2K Bug"
Previous message: Raymond Allo: "We have a working good looking treeview OCX in Forms5"
In reply to: Luis Gregorio: "Need help with SQL*Loader."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message