Create invisible column in Database Oracle 12c

HappyCode #0003 : Create invisible column in Database Oracle 12c

Invisible column, in some cases it can help to keep data invisible in general queries (*). 

We can take a look from this sample to get some ideas.

DROP TABLE city_t ;

CREATE TABLE city_t (
  id          NUMBER,
  name VARCHAR2(100) INVISIBLE,
  city VARCHAR2(100) 
);

insert into city_t values (1,'my city 1');
insert into city_t (id, name, city) values (2,'Tony','my city 2');
commit ;

select * from city_t ;

select id, name, city from city_t; 

Github : https://github.com/happycodingkoe/database_oracle/tree/master/Readmeshare_0003_ORA_InvisbleCol
Blog : https://happycodingkoe.blogspot.com/
IG : @happycodingkoe
FB : https://web.facebook.com/happycoding.koe.3