Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C
ocuments and Settings
ew>sqlplus pdm432/123
SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 10 10:54:56 2008
Copyright (c) 1982, 2005, Oracle.All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> set serverout on
SQL> declare
2str varchar2(10000);
3v int;
4begin
5for i in 1 .. 1000 loop
6str := str || '1234567890';
7end loop;
8v := length(str);
9dbms_output.put_line('str len:' || to_char(v));
10end;
11/
str len:10000
PL/SQL 过程已成功完成。
SQL> declare
2str varchar2(10000);
3v int;
4begin
5for i in 1 .. 1000 loop
6select str || '1234567890' into str from dual;
7end loop;
8v := length(str);
9dbms_output.put_line('str len:' || to_char(v));
10end;
11/
declare
*
第 1 行出现错误:
ORA-01489: 字符串连接的结果过长
ORA-06512: 在 line 6
