declare value varchar2(30); begin value := 'SQL'; execute immediate value; end; /
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))这段哪儿错了??
value varchar2(30);
begin
value := 'SQL';
execute immediate value;
end;
/
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))这段哪儿错了??
Declare
p_Value varchar2(30);p_Value:='SQL';dbms_output.put_line(p_Value);see plsql basic syntax.