Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL * Loader : Load data with format YYYYMMDDHH24MISSmmm

60716Mar 1 2006 — edited Jul 14 2006

Hi,

Please advice how to load data with format YYYYMMDDHH24MISSmmm (Year, Month, Day, Hour, Minute, Second, Milliseconds) into an Oracle Table using SQL * Loader.

- What format should I give in the control file?
- What would be the column type to create the table to load data.

Sample data below;

YYYYMMDDHH24MISSmmm
20060222105559020
20060222105559520
20060221141905027
20060221141905637
20060222150224193

Thanks in advance
SUN

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2006

Added on Mar 1 2006

#general-database-discussions

5 comments

7,589 views