Oracle 12C -- Invisible Columns
标签：
Oracle 12C -- Invisible Columns
> drop table needsinvisiblecolumn;
SQL> create table hasinvisiblecolumn(id number,goodbye_column number invisible);
SQL> create table needsinvisiblecolumn(id number,goodbye_column number);
SQL> alter table needsinvisiblecolumn modify (goodbye_column invisible);
SQL> select owner,table_name,column_name,hidden_column from dba_tab_cols where hidden_column=‘YES‘ and owner=‘SCOTT‘;
OWNER TABLE_NAME COLUMN_NAME HID
------------------------------ ------------------------------ ------------------------------ ---
SCOTT HASINVISIBLECOLUMN GOODBYE_COLUMN YES
SCOTT NEEDSINVISIBLECOLUMN GOODBYE_COLUMN YES
SQL>