oracle 12c 新特性 invisible column tips

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