-- Oracle 12c: Security Features 

ENCRYPTION_WALLET_LOCATION =
 (SOURCE = (METHOD = FILE) 
   (METHOD_DATA = (/oracle/DB_WALLET/database_name)
   )
 )
;

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY 'onetwothree';  

-- Credit Card Transaction Table
CREATE TABLE credit_card_transactions
(user_id              NUMBER(20) GENERATED BY DEFAULT AS IDENTITY  
                       (START WITH 1 INCREMENT BY 1) PRIMARY KEY,
 cc_number            VARCHAR2(30)  ENCRYPT  SALT|NOSALT,
 transaction_date     DATE,
 transaction_amount   NUMBER(20,2),
 create_date          TIMESTAMP  DEFAULT SYSTIMESTAMP(3)
);


ALTER TABLE credit_card_transactions MODIFY (
   cc_number   ENCRYPT USING  'AES256'  SALT
);


CREATE TABLESPACE  ts_cc_tran_data  DATAFILE SIZE 100M
AUTOEXTEND ON NEXT 50M
ENCRYPTION USING 'AES256'
DEFAULT STORAGE(ENCRYPT)
;


ALTER SYSTEM SET ENCRYPTION WALLET OPEN  IDENTIFIED BY 'onetwothree'  
;

ALTER SYSTEM SET ENCRYPTION WALLET CLOSE
;

SELECT * FROM v$encryption_wallet
;