{暗号化}暗号化した列を含む表を作成

 

https://docs.oracle.com/cd/F19136_01/asoag/configuring-transparent-data-encryption.html#GUID-FC8D6E7E-CD47-4972-89B4-E90CB8A811AA

select * from v$encryption_wallet;

create table sh.enca(
 first_name varchar2(128),
 last_name varchar2(128),
 empid number,
 salary number(6) encrypt
);

create table sh.encb(
 col1 number,
 col2 number encrypt no salt,
 col3 number encrypt using '3des168'
);

create table sh.encc(
 col1 number,
 col2 number encrypt 'nomac' no salt,
 col3 number
);

select * from all_encrypted_columns;