strSQL := 'select ''' || V_date_begin || '''' || '''至''' || --V_date_end||
-- '''||v.Account_Name||'''||'''_帐户收到款'''||
' as c_desc,(kmdm) as c_acc,KM_NAME, ' || '''借''' ||
' as jdbz,sum(v.money_detail) as money_total from view_incomeline_km v ' ||
' where pay_date>=''' || V_date_begin || '''' ||
' and pay_date<=''' || V_date_end || '''' ||
' and v.district_no=''' || V_districtNo || '''' ||
'group by Account,kmdm,KM_NAME'; open C_Cursora for strsql;其中:V_date_begin ,V_date_end,V_districtNo , C_Cursora 为变量,想实现查询的结果如下:2008-01-01至2008-04-01交通银行_帐户收到款,20101,行政事业性收入,借,5623.50求助,谢谢!
-- '''||v.Account_Name||'''||'''_帐户收到款'''||
' as c_desc,(kmdm) as c_acc,KM_NAME, ' || '''借''' ||
' as jdbz,sum(v.money_detail) as money_total from view_incomeline_km v ' ||
' where pay_date>=''' || V_date_begin || '''' ||
' and pay_date<=''' || V_date_end || '''' ||
' and v.district_no=''' || V_districtNo || '''' ||
'group by Account,kmdm,KM_NAME'; open C_Cursora for strsql;其中:V_date_begin ,V_date_end,V_districtNo , C_Cursora 为变量,想实现查询的结果如下:2008-01-01至2008-04-01交通银行_帐户收到款,20101,行政事业性收入,借,5623.50求助,谢谢!
解决方案 »
- Ubuntu装oracle后:product和admin文件夹为空
- oracle函数的使用问题
- redo
- 求一行列互换的SQL
- 求教 应用程序的oracle连接出错问题
- about Error : ORA-01031 insufficicient privileges !
- 在xp中能安装oracle816吗?急……在线等待
- 有关form的菜菜问题,求助!!!
- oracle 数据库中行数的问题。
- ORACLE怎样查询一个字段,但是这个字段同时满足另外两个字段的取值条件,并且as别名
- ORACLE怎么识别数据库连来源,是程序连接的还是ORACLE本身自带的管理软件(sqlplus/plsqldev等)
- sql
||' (kmdm) as c_acc,'
||' KM_NAME, '
||' ''借'' as jdbz,'
||' sum(v.money_detail) as money_total '
||' from view_incomeline_km v '
||' where pay_date>='||V_date_begin
||' and pay_date<='||V_date_end
||' and v.district_no='||V_districtNo
||' group by Account,kmdm,KM_NAME'
自己再测试看看吧,应该就是这样的吧
||' (kmdm) as c_acc,'
||' KM_NAME, '
||' ''借'' as jdbz,'
||' sum(v.money_detail) as money_total '
||' from view_incomeline_km v '
||' where pay_date>=' ||V_date_begin
||' and pay_date <=' ||V_date_end
||' and v.district_no=' ||V_districtNo
||' group by Account,kmdm,KM_NAME';open C_Cursora for strsql;
提示:“未找到预期from关键字”v.Account_Name'为字段名称,V_date_begin ,V_date_end,V_districtNo , C_Cursora 为变量,view_incomeline_km 为视图。