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.* ...