kangcsdan的博客

Oracle UTL_FILE出力csv文件汉子显示乱码

-- Oracle 12 clone Pluggable Database（数据库安装的电脑【服务端】）运行cmd-- 1. C:\Users\Administrator>sqlplus sys/SYSTEM@cdb as sysdba显示当前在哪个容器CDB-- 2. show con_name / select sys_context('USERENV','CON_NAME'...

默认排序SELECT ROW_NUMBER () OVER (ORDER BY GP_NO, HASEI_DT, GP_LINE, INOUT_CNT, OCCUR_KBN, JYUCHU_DATE) actyRowNo, AA.*改变排序后SELECT ROW_NUMBER () OVER (ORDER BY HCTANTO_ID ASC) actyRowNo, AA.*...