create table tq84_invis_col (
col_a number,
col_b number invisible,
col_c number
);
insert into tq84_invis_col (col_a, col_b, col_c) values (1, 2, 3);
Data dictionary:
select
col.column_id,
col.column_name,
col.data_type
from
user_tab_columns col
where
col.table_name = 'TQ84_INVIS_COL'
order by
col.column_name;
--
-- COLUMN_ID COLUMN_NAME DATA_TYPE
-- --------- ----------- ---------
-- 1 COL_A NUMBER
-- COL_B NUMBER
-- 2 COL_C NUMBER