Oracle 12c 新特性 invisible column Tips
不可见列: invisible
[email protected]> create table tab_invisible(col1 varchar2(10),col2 number, col3 varchar2(10) invisible);
Table created.
[email protected]> desc tab_invisible
Name Null? Type
----------------------------------------- -------- ----------------------------
COL1 VARCHAR2(10)
COL2 NUMBER
[email protected]> set colinvisible on
[email protected]> desc tab_invisible
Name Null? Type
----------------------------------------- -------- ----------------------------
COL1 VARCHAR2(10)
COL2 NUMBER
COL3 (INVISIBLE) VARCHAR2(10)
[email protected]>
[email protected]> insert into tab_invisible values('aaaaa',1);
1 row created.
[email protected]>
[email protected]> insert into tab_invisible values('aaaaa',1,'invisible');
insert into tab_invisible values('aaaaa',1,'invisible')
*
ERROR at line 1:
ORA-00913: too many values
[email protected]>
[email protected]> insert into tab_invisible(col1,col2,col3) values('aaaaa',1,'invisible');
1 row created.
[email protected]>
插入数据时候需要指定列名(不可见列)
通过 set colinvisible on/off 来查看 invisible的情况
[email protected]> alter table tab_invisible modify (col3 visible);
Table altered.
[email protected]> desc tab_invisible;
Name Null? Type
----------------------------------------- -------- ----------------------------
COL1 VARCHAR2(10)
COL2 NUMBER
COL3 VARCHAR2(10)
[email protected]>
To be continue….
Have a good life! 2018/07 via LinHong
近期评论