Oracle使用PLSQL导出CSV文件,数字显示科学计数法问题
解决方法: 将查询的字段写成如下方式SELECT '="'||PK_MSGINFO|| '"' as PK_MSGINFO,BILLTYPE,'="'||PK_BILL|| '"' as PK_BILL,MSGTYPE,'="'||PROCESSID|| '"' as PROCESSID,'="'||WORKITEMID|| '"' as WORKITEMID,OPERATOR,'="'||PK_OPER|| '"' as PK_OPER,'="'||OPERUNITCODE|| '"'
原创
2021-05-10 18:54:28 ·
3089 阅读 ·
2 评论