Invisible Column Oracle 12C

Column Can be defined as Invisible

column_can_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);


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


Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.


Python if , elif and else

Python Conditions and If statements

  • 0
Python for beginners

Learning Python Part 1

  • 3
Struct Alignment and Padding

Struct Alignment and Padding in C++ And C

  • 0
Friend function

Friend function C++

  • 0
Pointers

C++ Pointers

  • 0
Structures

C++ Structures

  • 0
Types of Inheritance in C++

Inheritance and access specifiers C++

  • 0
Java date pattern

Java Date Pattern Syntax

  • 0
Java Date and Calendar

Java Date formats

  • 0
JAVA Data Type

Data types in Java

  • 0
Java unreachable code

Unreachable Code Error in Java

  • 0

Post Comment

Comments(0)

WEB TECHNOLOGY

Articles

×

Forgot Password

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