TXT

SQL

By Leo Franklin,2014-01-21 02:09
11 views 0
SQL SQL SQL SQL SQL SQL SQL SQL SQL

    以下的 J2EE 应用程序已经配置, 并且可用下面列出的 URL 来访问。

    数据库配置文件已经安装到 D:\oracle\product\10.1.0,同时其他选定的安装组件也已经安装到 D:\oracle\product\10.1.0\db_1

    Ultra Search URL:

    http://ytyu:5620/ultrasearch

Ultra Search 管理工具 URL:

    http://ytyu:5620/ultrasearch/admin

iSQL*Plus URL:

    http://ytyu:5560/isqlplus

Enteprise Manager 10g Database Control URL:

    http://ytyu:5500/em

    www.1804945339@qq.com(1804945339) 女孩

plSQL

注册

product code :4v6hkjs66vc944tp74p3e7t4gs6duq4m4szbf3t38wq2

    serial number:1412970386

    password: xs374ca

    lincense number :999

百度账号

    shanshanyu2012

    shanshanyu

insert into caiwu_q_temp_hj

     select ROW_NUMBER()over(order by TO_DATE ) as ROW a.waybill_no,

     count(a.waybill_no),

     a.express_status,

     a.oper_org_code

     from ytstl.t_stl_exp_charge a

     WHERE oper_time >= TO_DATE('2011-10-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS')

     AND oper_time < TO_DATE('2011-11-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS')

     -- and e.express_status='01'

     group by oper_org_code, waybill_no, express_status having count(waybill_no) > 1

    union

    select e.waybill_no,

     count(e.waybill_no),

     e.express_status,

     e.oper_org_code

     from ytstl.t_stl_exp_charge_archive e

     WHERE e.oper_time >= TO_DATE('2011-10-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS')

     AND e.oper_time < TO_DATE('2011-11-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS')

     -- and e.express_status='01'

     group by e.oper_org_code, e.waybill_no, e.express_status

having count(waybill_no) > 1

and oper_org_code in

     (select t.code

     from ytmdm.t_mdm_org t

     where t.type = 'TRANSFER_CENTER')

    and e.oper_org_code in

     (select t.code

     from ytmdm.t_mdm_org t

     where t.type = 'TRANSFER_CENTER')

Report this document

For any questions or suggestions please email
cust-service@docsford.com