Oracle 12cR2 DBMS_CRYPTO

Oracle DBMS_CRYPTO_INTERNAL Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

ALL_APPLY_CONFLICT_COLUMNS	DBA_TAB_COLS_V$	KU$_TAB_ONLY_STATS_VIEW
ALL_APPLY_KEY_COLUMNS	DBA_TAB_COLUMNS	USER_COL_PENDING_STATS
ALL_APPLY_TABLE_COLUMNS	DBA_TAB_COL_STATISTICS	USER_NESTED_TABLE_COLS
ALL_COL_PENDING_STATS	DBA_TAB_HISTGRM_PENDING_STATS	USER_PART_COL_STATISTICS
ALL_NESTED_TABLE_COLS	DBA_TAB_HISTOGRAMS	USER_PART_HISTOGRAMS
ALL_PART_COL_STATISTICS	DBA_TSTZ_TABLES	USER_PUBLISHED_COLUMNS
ALL_PART_HISTOGRAMS	DBA_TSTZ_TAB_COLS	USER_SUBPART_COL_STATISTICS
ALL_SUBPART_COL_STATISTICS	EXU10ASC	USER_SUBPART_HISTOGRAMS
ALL_SUBPART_HISTOGRAMS	EXU10ASCU	USER_TAB_COLS
ALL_TAB_COLS	EXU8ASC	USER_TAB_COLS_V$
ALL_TAB_COLS_V$	EXU8ASCU	USER_TAB_COLUMNS
ALL_TAB_COLUMNS	EXU8HST	USER_TAB_COL_STATISTICS
ALL_TAB_COL_STATISTICS	EXU8HSTU	USER_TAB_HISTGRM_PENDING_STATS
ALL_TAB_HISTGRM_PENDING_STATS	KU$_10_1_HISTGRM_MAX_VIEW	USER_TAB_HISTOGRAMS
ALL_TAB_HISTOGRAMS	KU$_10_1_HISTGRM_MIN_VIEW	USER_TSTZ_TABLES
CRYPTO_INTERNAL_LIB	KU$_10_1_PTAB_COL_STATS_VIEW	USER_TSTZ_TAB_COLS
DBA_COL_PENDING_STATS	KU$_10_1_PTAB_STATS_VIEW	WM$COLUMN_PROPS
DBA_LOGSTDBY_EDS_SUPPORTED	KU$_10_1_TAB_COL_STATS_VIEW	WM$DBA_TAB_COLS
DBA_NESTED_TABLE_COLS	KU$_10_1_TAB_ONLY_STATS_VIEW	WM_COMPRESS_BATCH_SIZES
DBA_PART_COL_STATISTICS	KU$_10_1_TAB_STATS_VIEW	_HISTGRM_DEC
DBA_PART_HISTOGRAMS	KU$_10_2_TAB_STATS_VIEW	_HIST_HEAD_DEC
DBA_PUBLISHED_COLUMNS	KU$_11_2_TAB_STATS_VIEW	_OPTSTAT_HISTGRM_HISTORY_DEC
DBA_SUBPART_COL_STATISTICS	KU$_COL_STATS_VIEW	_OPTSTAT_HISTHEAD_HISTORY_DEC
DBA_SUBPART_HISTOGRAMS	KU$_HISTGRM_VIEW	_user_stat
DBA_TAB_COLS	KU$_PTAB_STATS_VIEW	_user_stat_varray

Documented No

First Available 12.2.0.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtcia.plb

Subprograms

STATSDECRYPTNUM	STATSENCRYPTNUM	UPDATESENSITIVESTATS
STATSDECRYPTRAW	STATSENCRYPTRAW

STATSDECRYPTNUM (new 12.2)

Undocumented dbms_crypto_internal.statsDecryptNum( obj_nbr IN NUMBER, col_nbr IN NUMBER, encrypted_num IN NUMBER) RETURN NUMBER;

DECLARE

       objNum        
      sys.wri$_optstat_histhead_history.obj#%TYPE := 8476;

       intCol        
      sys.wri$_optstat_histhead_history.intcol#%TYPE := 1;

 encryptMinVal sys.wri$_optstat_histhead_history.minimum_enc := 2199;

      BEGIN

        dbms_crypto_internal.statsDecryptNum(obj#, intcol#, minimum_enc);

      END;

      /

STATSDECRYPTRAW (new 12.2)

Undocumented dbms_crypto_internal.statsDecryptRaw( obj_nbr IN NUMBER, col_nbr IN NUMBER, ciphertext IN RAW) RETURN RAW;

exec dbms_crypto_internal.statsDecryptRaw( obj#, intcol#, lowval);

STATSENCRYPTNUM (new 12.2)

Undocumented dbms_crypto_internal.statsEncryptNum( obj_nbr IN NUMBER, col_nbr IN NUMBER, num_in_clear IN NUMBER) RETURN RAW;

TBD

STATSENCRYPTRAW (new 12.2)

Undocumented dbms_crypto_internal.statsEncryptRaw( obj_nbr IN NUMBER, col_nbr IN NUMBER, cleartext IN RAW) RETURN RAW;

TBD

UPDATESENSITIVESTATS (new 12.2)

Undocumented dbms_crypto_internal.updateSensitiveStats;

exec dbms_crypto_internal.updateSensitiveStats;