oracle sqlplus per,关于sqlplus单行最大长度的问题-优快云博客

小弟在shell中拼接了一个字符串，然后放在sqlplus中执行，报错，后来通过spool on将sql显示出来发现将其自动截断了，结果如下：

SQL> SELECT

2 'Record' || ' ' ||

3 B.USERNAME || ' ' ||

4 SUM(A.VALUE)

5 FROM

6 V$SESSTAT A,V$SESSION B

7 WHERE

8 A.SID = B.SID

9 AND A.STATISTIC# = 12

10 AND B.USERNAME IS NOT NULL

11 and (1<1 or (upper(B.username)=upper('WKSYS')) or (upper(B.username)=upper('WKPROXY')) or (upper(B.username)=upper('SYSTEM'))

or (upper(B.username)=upper('SYS')) or (upper(B.username)=upper('SH')) or (upper(B.username)=upper('SCOTT')) or (upper(B.username)=

upper('QS_WS')) or (upper(B.username)=upper('QS_OS')) or (upper(B.username)=upper('QS_ES')) or (upper(B.username)=upper('QS_CS')) or

(upper(B.username)=upper('QS_CBADM')) or (upper(B.username)=upper('QS_CB')) or (upper(B.username)=upper('QS_ADM')) or (upper(B.user

name)=upper('QS')) or (upper(B.username)=upper('PUBLIC')) or (upper(B.username)=upper('PM')) or (upper(B.username)=upper('OUTLN')) o

r (upper(B.username)=upper('ORDSYS')) or (upper(B.username)=upper('ORDPLUGINS')) or (upper(B.username)=upper('OLAPSYS')) or (upper(B

.username)=upper('OE')) or (upper(B.username)=upper('ODM_MTR')) or (upper(B.username)=upper('ODM')) or (upper(B.username)=upper('MDS

YS')) or (upper(B.username)=upper('HR')) or (upper(B.username)=upper('DBSNMP')) or (upper(B.username)=up

12 per('CTXSYS')) or (upper(B.username)=upper('ANONYMOUS')))

13 GROUP BY

14 B.USERNAME;

and (1<1 or (upper(B.username)=upper('WKSYS')) or (upper(B.username)=upper('WKPROXY')) or (upper(B.username)=upper('SYSTEM')) or (

upper(B.username)=upper('SYS')) or (upper(B.username)=upper('SH')) or (upper(B.username)=upper('SCOTT')) or (upper(B.username)=upper

('QS_WS')) or (upper(B.username)=upper('QS_OS')) or (upper(B.username)=upper('QS_ES')) or (upper(B.username)=upper('QS_CS')) or (upp

er(B.username)=upper('QS_CBADM')) or (upper(B.username)=upper('QS_CB')) or (upper(B.username)=upper('QS_ADM')) or (upper(B.username)

=upper('QS')) or (upper(B.username)=upper('PUBLIC')) or (upper(B.username)=upper('PM')) or (upper(B.username)=upper('OUTLN')) or (up

per(B.username)=upper('ORDSYS')) or (upper(B.username)=upper('ORDPLUGINS')) or (upper(B.username)=upper('OLAPSYS')) or (upper(B.user

name)=upper('OE')) or (upper(B.username)=upper('ODM_MTR')) or (upper(B.username)=upper('ODM')) or (upper(B.username)=upper('MDSYS'))

or (upper(B.username)=upper('HR')) or (upper(B.username)=upper('DBSNMP')) or (upper(B.username)=up

ERROR at line 11:

ORA-00907: missing right parenthesis

SQL> spool off

但是实际上的sql是