摘要: select substr('JSL180415051260',4,4) from dual select substr('JSL180415051260',8,6) from dual select sysdate from dual 阅读全文
posted @ 2016-03-09 15:41 蕭慶蘋 阅读(1462) 评论(0) 推荐(0) 编辑
摘要: INSERT INTO openquery(TEST_WDPIS, 'SELECT COMPANY_NO,SLIP_TYPE,CT_NO,D_DATE,SYS_USER FROM fn_out_tm')values ('A','B','C',getdate(),'d') select * from 阅读全文
posted @ 2016-03-09 15:39 蕭慶蘋 阅读(910) 评论(0) 推荐(0) 编辑