错误信息 'access violation at address 010F0167 in module 'dbexpora.dll'.write of address 00000000'
不知道你的乘法的结果中有没有暴大的,我怀疑是不是有可能超过数据上限,当然,不是oracle的上限,而是 dbexpora.dll中关于浮点(或整形)的上限,可否试一下这样'select a,b,c,to_char(a*b+b*c) aa from abc where ....'
a,b,c是否为整型类型数据?aa是a*b+b*c所得出来的列吧 sql:='select a,b,c,a*b+b*c aa from abc where ....';
a是char,但是奇怪为什么在pl/sql下能通过呢.
a,c都是char sql:='select a,b,c,to_number(a)*b+b*to_number(c) aa from abc where ....'; 这样还是报错啊.
楼主分开试一下,看看这样有没有错, sql:='select a,b,c,a*b aa, from abc where ....'; sql:='select a,b,c,b*c bb from abc where ....'; sql:='select a,b,c,a*b aa, b*c bb from abc where ....';
'access violation at address 010F0167 in module 'dbexpora.dll'.write of address 00000000'
dbexpora.dll中关于浮点(或整形)的上限,可否试一下这样'select a,b,c,to_char(a*b+b*c) aa from abc where ....'
sql:='select a,b,c,a*b+b*c aa from abc where ....';
sql:='select a,b,c,to_number(a)*b+b*to_number(c) aa from abc where ....';
这样还是报错啊.
sql:='select a,b,c,a*b aa, from abc where ....';
sql:='select a,b,c,b*c bb from abc where ....';
sql:='select a,b,c,a*b aa, b*c bb from abc where ....';
空可以这样处理 nvl(a,'0')
汉字你也乘法,有想象力,PFPF
PS:我的印象中ORACLE中字段别名的话,要用AS的吧?