zhending2000 发表于 2012-1-1 14:46
SQL?
SQL> SELECT to_char(a.charge_id) charge_id,
2a.partition_id, a.eparchy_code, a.city_code, to_char(a.cust_id) cust_id,
3to_char(a.user_id) user_id, a.serial_number, a.net_type_code,
4to_char(a.acct_id) acct_id, a.channel_id, a.payment_id,
5a.pay_fee_mode_code, a.payment_op, to_char(a.recv_fee) recv_fee,
6to_char(a.limit_money) limit_money, to_char(a.recv_time, 'yyyy-mm-dd hh24:mi:ss') recv_time,
7a.recv_eparchy_code, a.recv_city_code, a.recv_depart_id, a.recv_staff_id,
8a.payment_reason_code, a.input_no, a.input_mode, a.outer_trade_id, a.act_tag,
9a.extend_tag, a.action_code, to_char(a.action_event_id) action_event_id,
10a.payment_rule_id, a.remark, a.cancel_tag, a.cancel_staff_id, a.cancel_depart_id,
11a.cancel_city_code, a.cancel_eparchy_code,
12to_char(a.cancel_time, 'yyyy-mm-dd hh24:mi:ss') cancel_time,
13to_char(a.cancel_charge_id) cancel_charge_id, to_char(a.rsrv_fee1) rsrv_fee1,
14to_char(a.rsrv_fee2) rsrv_fee2, a.rsrv_info1, b.payment, c.action_name
15 FROM UCR_ACT1.tf_b_paylog a,UCR_PARAM.td_b_payment b, UCR_PARAM.td_b_discnt_action c
16
WHERE a.partition_id >=:VBEGIN_PARTITION_ID
17
AND a.partition_id =TO_DATE(:VBEGIN_RECV_TIME, 'YYYY-MM-DD HH24:MI:SS')
20
AND a.recv_time+0<=TO_DATE(:VEND_RECV_TIME, 'YYYY-MM-DD HH24:MI:SS')
21
AND a.action_code=c.action_code(+)
22
AND a.payment_id=b.payment_id(+);
|