select id,metaName,material_name,purchasingPrice as price,unit,spec ,packingUnit_S,S2sub,
(select cast(nvl(purchasingPrice,0) as varchar(50)) || '/'||packingUnit from YK_23_inStock a join
YK_23_inStock_detail b on a.inStock_id=b.inStock_id where rownum<=1 and b.medicine_code=material.id and
charge_type=9 and inType=1 order by b.id desc ) purchasingPrice_old from material where rownum<=10 and
Hospital_ID=1 and isOut=1 子查询里的order by b.id desc 这里报错。显示缺失右括号。可是看不出来错误在哪 0 0.还望大神指导下
(select cast(nvl(purchasingPrice,0) as varchar(50)) || '/'||packingUnit from YK_23_inStock a join
YK_23_inStock_detail b on a.inStock_id=b.inStock_id where rownum<=1 and b.medicine_code=material.id and
charge_type=9 and inType=1 order by b.id desc ) purchasingPrice_old from material where rownum<=10 and
Hospital_ID=1 and isOut=1 子查询里的order by b.id desc 这里报错。显示缺失右括号。可是看不出来错误在哪 0 0.还望大神指导下
解决方案 »
- oracle 修改表字段 (批量修改)
- tnsping 问题
- EXECUTE IMMEDIATE于dbms_sql.parse在有什么区别啊???
- 我10g的。为什么查询表格里的字符和中文是问号?
- oracle9i,10g什么意思?
- oracle 数据库备份与恢复
- 如何把一个表中的number类型的字段的定义取出来,插入到另外一张表中?
- 文本文件是否可以导入oracle 数据库?
- ASP连接ORACLE运行正常,但有时会出现数据无法读取情况
- 求各位大大推荐学习oracle数据库的书。
- ORACLE 11g2.0.3安装问题
- java web连接oracle dataguard的时候应用层是通过什么做到读写分离的
order by 字句去掉就行了吧