Testing DATE is correct with Oracle Loader

From: Stefan Duffner <stefan.duffner_at_web.de>
Date: 7 Aug 2001 08:18:18 -0700
Message-ID: <1a77e8d0.0108070718.23649226_at_posting.google.com>

Hello,

[Quoted] [Quoted] I have a problem with Oracle Loader and I hope anyone can help me. I try to import data from a textfile into Oracle which works perfectly.
But I have some fields of DATE type and in these textfiles have sometimes incorrect dates like 33. of month etc.. But I want to put these data, which have incorrect date, into a discard file, but I dont know how I can check the date and writing it into the discard file.

Thanks for any help
Stefan Received on Tue Aug 07 2001 - 17:18:18 CEST

This message: [ Message body ]
Next message: Venki Ramachandran: "Re: Testing DATE is correct with Oracle Loader"
Previous message: Sybrand Bakker: "Re: Sql*Plus in Shell Script Question"
Next in thread: Venki Ramachandran: "Re: Testing DATE is correct with Oracle Loader"
Reply: Venki Ramachandran: "Re: Testing DATE is correct with Oracle Loader"
Reply: Ram Lakshminarayanan: "Re: Testing DATE is correct with Oracle Loader"
Maybe reply: Stefan Duffner: "Re: Testing DATE is correct with Oracle Loader"

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

Original text of this message