|
# 1231
lala
|
|
|
 To:
这两天感冒了，打了好多喷嚏，电视上说打喷嚏的时候如果睁着眼睛，眼珠子会掉出来，不知道是不是真的，不敢试
From: lala
2005.08.16 13:56
|
|
|
|
|
 To: lala
谁讲的这么恐怖的故事，肯定是假的。
From: eygle
2005.08.16 15:29
|
|
|
|
|
# 1227
lala
|
|
|
To: cctv
还是你的网站比较快阿
From: lala
2005.08.15 16:14
|
|
|
|
|
 To: lala
那就常来看看吧！
From: eygle
2005.08.15 22:49
|
|
|
|
|
# 1224
hubert
来自: 南京
|
 |
|
 |
|
|
To: eygle
一个问题请教，用dbms_lob.loadfromfile读取一个含有汉字的文本文件，
在sql*plus中为何显示成乱码？
过程如下：
SQL> create table t(
2name varchar2(30),
3contentclob,
4constraint pk_t primary key (name)
5using index tablespace hubert_index
6);
表已创建。
SQL> create or replace directory dir1 as 'd:\test';
目录已创建。
SQL> declare
2l_bfilebfile;
3l_clob clob;
4l_strvarchar2(1000);
5begin
6insert into t(name,content)
7values ('test.txt',empty_clob())
8return content into l_clob;
9l_bfile:=bfilename('DIR1','test.txt');
10dbms_lob.fileopen(l_bfile);
11dbms_lob.loadfromfile(l_clob,l_bfile,dbms_lob.getlength(l_bfile));
12dbms_lob.fileclose(l_bfile);
13commit;
14exception when others then
15l_str:=sqlerrm(sqlcode);
16dbms_output.put_line(l_str);
17end;
18/
PL/SQL 过程已成功完成。
SQL> select name,dbms_lob.getlength(content) from t;
NAME DBMS_LOB.GETLENGTH(CONTENT)
------------------------------ ---------------------------
test.txt 118
已选择 1 行。
SQL> select content from t;
CONTENT
--------------------------------------------------------------------------------
？？？？？？？？汣扯？煳?汰獵？？？？？？？？？？？？？？？？汣扯？？？？
已选择 1 行。
SQL> select * from nls_session_parameters;
PARAMETERVALUE
------------------------------ -----------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORYCHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMATYYYY-MM-DD HH24:MI:SS
NLS_DATE_LANGUAGESIMPLIFIED CHINESE
NLS_SORT BINARY
NLS_TIME_FORMATHH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCYRMB
NLS_COMP BINARY
已选择15行。
SQL> select * from nls_instance_parameters;
PARAMETERVALUE
------------------------------ -----------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORYAMERICA
NLS_SORT
NLS_DATE_LANGUAGE
NLS_DATE_FORMAT
NLS_CURRENCY
NLS_NUMERIC_CHARACTERS
NLS_ISO_CURRENCY
NLS_CALENDAR
NLS_TIME_FORMAT
NLS_TIMESTAMP_FORMAT
NLS_TIME_TZ_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_DUAL_CURRENCY
NLS_COMP
已选择15行。
SQL> select * from nls_database_parameters;
PARAMETERVALUE
------------------------------ -----------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORYAMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET ZHS16GBK
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMATDD-MON-RR
NLS_DATE_LANGUAGEAMERICAN
NLS_SORT BINARY
NLS_TIME_FORMATHH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY$
NLS_COMP BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
NLS_RDBMS_VERSION8.1.7.0.0
已选择18行。
------------------------------
如方便的话，请指点一下，谢谢！
From: hubert
2005.08.13 18:36
|
|
|
 |
|
 |
 |
|
 |
|
|
# 1219
lala
|
|
|
To: cctv
哈哈哈
From: lala
2005.08.11 16:42
|
|
|
|
|
To: lala
啦啦啦
From: eygle
2005.08.11 20:42
|
|
|
|
|
# 1218
xinjingcool
|
|
|
To:
大师，新闻组怎么不能象maillist一样订阅，直接发到mailbox里？
From: xinjingcool
2005.08.11 11:03
|
|
|
|
|
To: xinjingcool
可以的
From: eygle
2005.08.11 12:06
|
|
|
|
|
eygle.com
我要留言
To: lala
回复
编辑
To: lala
To: eygle
