test.sql

来自「Converting CSV Files to SQL using VB6」· SQL 代码 · 共 7 行

INSERT into tblbuilding (ID,PARTCODE,DESPATCHED,DESCRIPTION) VALUES (1,112, TO_DATE('30/12/1999 02:10:25','DD/MM/YY HH24:MI:SS') ,'This is a string');

INSERT into tblbuilding (ID,PARTCODE,DESPATCHED,DESCRIPTION) VALUES (2,173, TO_DATE('16/1/2001 17:20:04','DD/MM/YY HH24:MI:SS') ,'This is String No.2');

INSERT into tblbuilding (ID,PARTCODE,DESPATCHED,DESCRIPTION) VALUES (3,183, TO_DATE('14/11/02 14:28:02','DD/MM/YY HH24:MI:SS') ,'Date field includes time');