17,082
社区成员
发帖
与我相关
我的任务
分享
SQL> select * from NLS_SESSION_PARAMETERS where rownum <= 20;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
SQL> set serveroutput on
SQL> declare
2 v_var1 varchar2(10) := null;
3 begin
4 v_var1 := v_var1||chr(217);
5 if v_var1 is null then
6 dbms_output.put_line('null');
7 else
8 dbms_output.put_line('not null');
9 dbms_output.put_line(v_var1);
10 end if;
11 end;
12 /
null
PL/SQL 过程已成功完成。
SQL>
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
SQL>
SQL> set serveroutput on
SQL>
SQL> declare
2 v_var1 varchar2(10) := null;
3 begin
4 v_var1 := v_var1||chr(217);
5 if v_var1 is null then
6 dbms_output.put_line('null');
7 else
8 dbms_output.put_line('not null');
9 dbms_output.put_line(v_var1);
10 end if;
11 end;
12 /
not null
?
PL/SQL procedure successfully completed
SQL