| insert a hardcoded date in control file. [message #71951] |
Mon, 10 February 2003 16:32  |
Sabrina
Messages: 76
Registered: February 2002
|
Member |
|
|
My control file looks likes,
load data infile 'EDS1997.TXT'
into table PROC_CODES_HIST append
(
DUMMYDATE DATE 'MM/DD/YYYY' '01/01/2001'
)
i get the error
SQL*lOADER-466: Column "01/01/1997" does not exist in table PROC_CODES_HIST
any suggestions??
thanx
|
|
|
|
| Re: insert a hardcoded date in control file. [message #71952 is a reply to message #71951] |
Mon, 10 February 2003 21:06  |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
Try this:
DUMMYDATE CONSTANT "01-JAN-97"
This should workout. But depends on your default date
format as well. Hope you do not need to enter the time
part as well. In such a case we will have another
workaround to it.
DUMMYDATE "TO_DATE ('01-JAN-97 12:11', 'DD-MON-YY HH:MI')"
This will for sure work. ;-)
Sujit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
