比如下面的文本,一行作一条记录:
2002-08-2815:37
1,457,664 123.zip
2002-10-2909:40
89,402 a.jpg
2002-07-0203:25
ASFRoot
2002-10-2917:16
75,399 b.jpg
2002-07-0500:26
chenhu2
2002-09-2516:32
cxx
2002-07-0203:38
Documents and Settings
2002-10-3101:49
Downloads
2002-07-0203:27
Inetpub
1999-08-0217:07
jdk1.1.5
1999-08-0217:04
JMF1.1
2002-11-1212:09
0 lyw.txt
2002-11-1210:11
Microsoft UAM 卷
2002-09-0413:11
My Intranet
2002-07-0217:19
2,403 odbcconf.log
1998-09-2601:32
OPPGUIDE
2002-07-0204:26
orant
2002-08-2617:33
orant817
1999-08-0518:37
ORASIM
2002-07-0515:43
1,264 plsql101_test.prn
2002-07-0515:47
121 plsql101_test.sql
2002-11-1112:36
Program Files
1998-01-1407:00
46,256 SETUP.EXE
2002-07-0606:23
1,166 test.bmp
2002-11-1015:41
1,292 test.sql
1998-10-1307:39
354 USERGUID.HTM
2002-11-1112:33
WINNT
表示这样的:
createtabletest
(
testvarchar2(300);
);
如何做才行?
谢谢先! |