1。EXPORT 语句
EXPORT TO 'D:\DISCOUNT_RATE.del' OF DEL MODIFIED BY COLDEL2 SELECT 'insert into tablename values('||char(t.i)||','||char(t.load_time)||');' FROM CCP.DISCOUNT_RATE t; commit; 2。执行 3。察看DISCOUNT_RATE.del文件 "insert into tablename values(00000000.70 ,2007-08-28-11.29.58.173001);" |
|