<script language='javascript' src='http://www.taizhou.la/AD/ad.js'></script>
Related Articles
<script language='javascript' src='http://www.taizhou.la/AD/as.js'></script>
Author:NinGoo posted on NinGoo.net
在Oracle10g及以前版本的sqlplus中,不能直接显示blob或者bfile类型的数据:
SQL
>
create
table
t
(
b
blob
)
;
Table created .
SQL > insert into t values ( ' 1 ' ) ;
1 row created .
SQL > select * from t ;
SP2 - 0678 : Column or attribute type can not be displayed by SQL * Plus
Table created .
SQL > insert into t values ( ' 1 ' ) ;
1 row created .
SQL > select * from t ;
SP2 - 0678 : Column or attribute type can not be displayed by SQL * Plus
Oracle11g中,sqlplus的这个限制已经取消,可以在sqlplus中直接显示blob和bfile类型的数据:
SQL
>
create
table
t
(
b
blob
)
;
Table created .
SQL > insert into t values ( ' 1 ' ) ;
1 row created .
SQL > select * from t ;
B
--------------- --
1
Table created .
SQL > insert into t values ( ' 1 ' ) ;
1 row created .
SQL > select * from t ;
B
--------------- --
1
Related Articles
- Oracle11g新特性:server result cache续
- Installing Oracle Database 11g on Windows
- Oracle11g新特性:只读表(read only table)
- Oracle11g新特性:使用PIVOT/UNPIVOT进行行列转换
- 遭遇Oracle11g第一个bug
<script language='javascript' src='http://www.taizhou.la/AD/as.js'></script>