Try it here
Invisible Column Oracle 12C

Column Can be defined as Invisible


Another great new feature oracle 12C is to have a table column as invisible columm.

Invisible column is not being fetched when generic query like "select * from" is used.

Invisible column can only be queried by direct usage like "select invcolumn from table.."

This feature is useful especially when the column is not in use then instead of drop it,use Invisible column, or for some security reasons for example password column etc.

Below is the example:

ALTER TABLE t_my_tab  MODIFY (pwd invisible);

Writer profile pic

Admin on Jan 02, 2019 at 12:01 am

If you like and would like to contribute, you can write your article here or mail your article to . See your article appearing on the main page and help others to learn.

Post Comment

Comments( 0)




Forgot Password

Please enter your email address below and we will send you information to change your password.