View Execution

Oracle EE 19.16 Linux Redhat 7.9

My questions seem like something that I should be able to find Oracle documentation but I have had no luck finding it.

My company uses views extensively with some of the views decrypting encrypted data.

Example:

TABLE:

create table TABLE1

(

 COLUMN1  VARCHAR2(200) not null,  -- Encrypted data

 COLUMN2  NUMBER(10) not null,

 COLUMN3  CHAR(2) ,

 COLUMN4  NUMBER(10),

 COLUMN5  NUMBER(10) not null);

VIEW:

create or replace view VIEW1 as

select

 ENCRYPT.decrypt_string(COLUMN1) as COLUMN1, -- “ENCRYPT” is a package in our system.

 COLUMN1   as COLUMN1_ENC,

 COLUMN2,

 COLUMN3,

 COLUMN4,

 COLUMN5,

 case when COLUMN2 = 'UBCM' and COLUMN3 is not null and COLUMN4 = 'CA'