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
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/