Oracle 12C -- Invisible Columns
时间：2021-07-01 10:21:17
帮助过：3人阅读
>
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>
Oracle 12C -- Invisible Columns
标签：
