My data file (comma-separated) has two fields, one is a date, a time
the date, time
2015/5/7, 8:00:00
2015/5/7, 10:00:00
2015/5/7, 11:00:00
Now hope that through SQLLDR combine these two fields and warehousing to table a datetime field, like the following effect
a datetime
2015/5/7 8:00:00
2015/5/7 10:00:00
2015/5/7 11:00:00

Considered write a function to call, but the function, need to hand in, the date and time as parameters and my date and time are not to go alone into the Treasury to a certain field, also is the value of their only exist in the data file, how to bring out the two values involved, without storing them to their respective occupies a field in the table?

CodePudding user response:

 - there is no such import 
- try this, no environment test, not necessarily line; 
Column1 "to_date (: column1 | | column2, ' ' '- dd yyyy - mm hh24: mi: ss' ' ')", 
Column2 filler 

CodePudding user response:

reference 1st floor wmxcn2000 response:

 - no such import 
- try this, no environment test, not necessarily line; 
Column1 "to_date (: column1 | | column2, ' ' '- dd yyyy - mm hh24: mi: ss' ' ')", 
Column2 filler 

 - there is no such import 
- try this, no environment test, not necessarily line; 
- add a space 
Column1 "to_date (: column1 | | ' ' ' ' ' '| | column2,' ' '- dd yyyy - mm hh24: mi: ss' ' ')", 
Column2 filler 

CodePudding user response:

Thanks for wmxcn2000 great god help
But apparently this doesn't work, because column2 filler, also is the value of this column is skipped, not column2 column1 is referenced

CodePudding user response:

Very simple, the following

The date positon (xx: xx) date,
Time position (xx: xx) char,
A datetime field ": the date | | : time."