Oracle 12C不可见索引自测
SQL> create table look (id number(4),name varchar2(10),money number(10) invisible);
Table created.
SQL> insert into look values (1,'a',100);
insert into look values (1,'a',100)
*
ERROR at line 1:
ORA-00913: too many values
SQL> alter table look modify (money visible);
Table altered.
SQL> insert into look values (1,'a',100);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from look;
ID NAME MONEY
---------- ---------- ----------
1 a 100
SQL> alter table look modify (money invisible);
Table altered.
SQL> select * from look;
ID NAME
---------- ----------
1 a
SQL> select id,name,money from look;
ID NAME MONEY
---------- ---------- ----------
1 a 100
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/637517/viewspace-2147546/ ，如需转载，请注明出处，否则将追究法律责任。
