select count(1) as totalrow from (select t2.onenum,t2.allnum, t2.printstatus,t.apfd_code,t2.gidl_doc_numb, t2.orgid,t.bdgt_subj,t3.subjectcode,t3.subjectname, case when t.acst_id not in (887209,2001,3001,4001,5001,7001,8001,6066768) then decode(t2.fund_char,'0','预算内','1','其他财政性资金','2','其他','3','预算内（往年）','4','其他财政性资金（往年）','5','其他（往年）') else '其他' end as fund_char, t2.pay_amnt,t2.dtal_id,t2.item,t4.name,t.gath_org_name,t2.smry smry,t.acst_id from ga_t_apfd_bill t,sysmgr_org t1,ga_t_apfd_bill_dtal t2,busmgr_funnew t3,sysmgr_user t4 where 1=1 and t.gath_org_id = t1.orgid(+) and t.bdgt_subj=t3.subjectcode(+) and t.apfd_user_id=t4.userid(+) and t2.apfd_bill_id=t.apfd_bill_id and t.year=2012 and t3.year=2012 and t.ACST_ID=1001 and t.is_Del = 0 and t.status in ('4','5') and t2.gidl_doc_numb like %'414%' order by t1.orgcode,t.bdgt_subj, to_number(t.APFD_CODE))];nested exception is java.sql.SQLException: ORA-00911: 无效字符 谁知道这个哪儿错了吗
用pl sql自带的工具 也不是只能先查出数据来 再把数据导出
可以直接选中表名 导成dmp文件的
不知道是谁不懂装懂
谁知道这个哪儿错了吗