u011135852的博客

解决方法：进入工具-》导出表，接着如图操作，关键点在where子句来限制导出的数据

1、where sql： select * from c12_prod_hold_summary where position_dt >= 20170704 and position_dt between 20170701 and 20170704 and sk_f_prod in ('pd02170163', 'pd02xyzh08') and secu_type_code not in ('期货', '远期') and account_projec...

数值1到10的求法： SELECT 1 + ROWNUM - 1 FROM DUAL         CONNECT BY ROWNUM < 10 -1 +2; 日期20160101到20180630的求法： SELECT TO_NUMBER(TO_CHAR(TO_DATE(20160101,'YYYYMMDD') + ROWNUM - 1,'YYYYMMDD')) DT     ...