17,377
社区成员
发帖
与我相关
我的任务
分享
load data infile 'D:\temp\1.txt'
append
into table tmp_info
fields terminated by ''
(
id constant 0,
PHONENUMBER,
RECVTIME sysdate,
dealtime constant "to_date('20080912083000', 'yyyymmddhh24miss')",
operstatus constant 0,
level constant 8
)
OPER@tl>create table test(aaa number,bbb date,ccc number);
表已创建。
OPER@tl>select * from test;
AAA BBB CCC
---------- ------------------- ----------
1 2008-08-08 08:00:00 2.0010E+13
OPER@tl>/
AAA BBB CCC
---------- ------------------- ----------
1 2008-08-08 08:00:00 2.0010E+13
1 2008-08-08 08:00:00 11