SP2-0678: Column or attribute type can not be displayed by SQL*Plus,sp2-0678displayed

來源:互聯網
上載者:User

SP2-0678: Column or attribute type can not be displayed by SQL*Plus,sp2-0678displayed
在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

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

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.