Assume that we have following data which comes from a text file.
2013-02-17-15.26.18.014055
To load this data into Oracle DB we need specific timestamp format. ( via SQLLOADER)
Which is
TIMESTAMP "YYYY-MM-DD-HH24.MI.SS.FF"
Don try to give exact microsecond digits such as
TIMESTAMP "YYYY-MM-DD-HH24.MI.SS.FFFFFF"
That causes following error :
- ORA-01810: format code appears twice
Hiç yorum yok:
Yorum Gönder