Re: Working with constants in SQL*LOAD

>I am trying to use SQL*LOAD to load a file into a table. There are a date
>column (DATA_MOV) in whitch I whant to insert a constant (18000101)

Ehhh, what date is that? 01 Jan 1800 ?
Either make sure that the date you give uses the default format (most likely DD-MON-YY or DD-MON-RR):

    DATA_MOV constant '01-Jan-00' -- Oops!

or use double qoutes to specify any SQL statement

    DATA_MOV constant "to_date( '01-Jan-1800', 'DD-MON-YYYY')"

or

    DATA_MOV "to_date( '01-Jan-1800', 'DD-MON-YYYY')"

I hope one of those works,

Arjan. Received on Wed Aug 26 1998 - 12:20:29 CDT