iteye_1924的博客

select t4.pl_ssname, t.pl_sno, t2.knsum, t3.knsumSum, round(t2.knsum / t3.knsumSum * 100, 1) finish_pct, sum(t6.plan_pd) planpd from pd_wol t, (se...

select count(count_date) from (select to_char(b.ich_dadate, 'yyyy-mm-dd') count_date from ic_trnl a inner join ic_trnh b on b.ich_sno = a.ich_sno where to_char(b.i...

新下载的Oracle SQL Developer3.2解压打开默认为汉化版。习惯了使用英文版的开发工具的人，对汉化的软件使用反而不懂操作。故将SQL Developer换成英文版。进入SQL Developer解压目录sqldeveloper\bin文件夹下，找到sqldeveloper.conf文件。如我的：D:\oracle developer\sql...