宣言变量长度与实际内容不符

声明变量长度与实际内容不符
varchar2(2000) 为什么内容长度只有1056多，剩余的就显示不了呢，实际内容2100

使用语句：

SQL code

DECLARE  SQLSTR  VARCHAR2(4000);  V_DAYS  VARCHAR2(2);BEGIN  FOR I IN 1 .. 31 LOOP    IF I < 10 THEN      V_DAYS := '0' || I;    ELSE      V_DAYS := I;    END IF;    -- V_COUNT := V_COUNT + 1;    IF I < 16 THEN      SQLSTR := SQLSTR || ',max(case SUBJECT when ''D07' || V_DAYS ||                ''' then COUNTI else 0 end) as ''D07' || V_DAYS || '''' ||                CHR(10);        END IF;    END LOOP;  DBMS_OUTPUT.PUT_LINE(SQLSTR);  DBMS_OUTPUT.PUT_LINE(LENGTHB(SQLSTR));END;

显示文本：“,max(case SUBJECT when 'D0716' then COUNTI else 0 end) as 'D0716'
,max(case SUBJECT when 'D0717' then COUNTI else 0 end) as 'D0717'
,max(case SUBJECT when 'D0718' then COUNTI else 0 end) as 'D0718'
,max(case SUBJECT when 'D0719' then COUNTI else 0 end) as 'D0719'
,max(case SUBJECT when 'D0720' then COUNTI else 0 end) as 'D0720'
,max(case SUBJECT when 'D0721' then COUNTI else 0 end) as 'D0721'
,max(case SUBJECT when 'D0722' then COUNTI else 0 end) as 'D0722'
,max(case SUBJECT when 'D0723' then COUNTI else 0 end) as 'D0723'
,max(case SUBJECT when 'D0724' then COUNTI else 0 end) as 'D0724'
,max(case SUBJECT when 'D0725' then COUNTI else 0 end) as 'D0725'
,max(case SUBJECT when 'D0726' then COUNTI else 0 end) as 'D0726'
,max(case SUBJECT when 'D0727' then COUNTI else 0 end) as 'D0727'
,max(case SUBJECT when 'D0728' then COUNTI else 0 end) as 'D0728'
,max(case SUBJECT when 'D0729' then COUNTI else 0 end) as 'D0729'
,max(case SUBJECT when 'D0730' then COUNTI else 0 end) as 'D0730'
,max(case ”
显示长度：1056 


[解决办法]

探讨

打印是想做为调试语句来用，不是为了统计长度。
因此想打印出来了，但Oracle显示不全

查看更多 下一篇