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博客 ” ，链接：http://blog.itpub.net/637517/viewspace-2147546/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/637517/viewspace-2147546/