Oracle
Clover-Z
Don't live the same day twice!
展开
-
Oracle 游标的使用总结
declare --定义游标 cursor tcount is select to_number(to_char(d_create,'yyyy')) as fyear, vc_code as fsetid, l_fundid as fsetcode, vc_name as fsetname, nvl(to_原创 2017-03-31 14:58:28 · 455 阅读 · 0 评论 -
Oracle ORA-02069 此操作的 global_names 参数必须设置为 TRUE
执行的语句如下:insert into VF_VOUCHERDETAIL@V45fmdc ( C_ID, D_BIZ, C_PORT_CODE, C_ASSET_CODE, C_SUBJ_CODE, C_PORT_CLASS, C_CURY_CODE, C_VCH_NUM, C_VCH_NUM_S原创 2017-04-05 10:47:36 · 11951 阅读 · 0 评论