当 set nls_lang=american_america.zhs16gbk SQL> select substr('销售店名称',1,1) from dual;SUBSTR ------ 销 当set nls_lang=american_america.utf8 SQL> select substr('销售店名称',1,1) from dual; ERROR: ORA-01756: quoted string not properly terminated 该明白了吧
请问楼上:set nls_lang=american_america.utf8 是什么东东?
"sum(round(decode(A.传票号,'U1',A.差额,'UB',A.差额,round(A.出库数量*A.销售单价,2))*(1),2)) as 金额" 中的*(1)是什么意思?去掉后试试: sum(round(decode(A.传票号,'U1',A.差额,'UB',A.差额,round(A.出库数量*A.销售单价,2)),2)) as 金额
sorry,改为: sum(round(decode(A.传票号,'U1',A.差额,'UB',A.差额,A.出库数量*A.销售单价),2)) as 金额"
在SQL PLUS里提示的是 select 订单号,count(*) as numb from VV补给部品出库数据 GROUP BY 订单号 ORDER BY 订单号 *该语句的Order by 这里出错:Error in SQL statement, ORA-00907: 缺少右括号
既然对订单号分组就不用再排序了,分组是以升序 select 订单号,count(*) as numb from VV补给部品出库数据 GROUP BY 订单号
set nls_lang=american_america.zhs16gbk
SQL> select substr('销售店名称',1,1) from dual;SUBSTR
------
销
当set nls_lang=american_america.utf8
SQL> select substr('销售店名称',1,1) from dual;
ERROR:
ORA-01756: quoted string not properly terminated
该明白了吧
是什么东东?
中的*(1)是什么意思?去掉后试试:
sum(round(decode(A.传票号,'U1',A.差额,'UB',A.差额,round(A.出库数量*A.销售单价,2)),2)) as 金额
sum(round(decode(A.传票号,'U1',A.差额,'UB',A.差额,A.出库数量*A.销售单价),2)) as 金额"
select 订单号,count(*) as numb from VV补给部品出库数据 GROUP BY 订单号 ORDER BY 订单号 *该语句的Order by 这里出错:Error in SQL statement, ORA-00907: 缺少右括号
select 订单号,count(*) as numb from VV补给部品出库数据 GROUP BY 订单号