Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to create invisible index self-test in 12C. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

SQL > create table look (id number (4), name varchar2 (10), money number (10) invisible)

Table created.

SQL > insert into look values (1)

Insert into look values (1)

*

ERROR at line 1:

ORA-00913: too many values

SQL > alter table look modify (money visible)

Table altered.

SQL > insert into look values (1)

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

This is the end of this article on "how to create invisible index self-test". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.