VIEW: SYS.REDACTION_VALUES_FOR_TYPE_FULL

Source

View Text - Preformatted

select
  f.numbercol    number_value,
  f.binfloatcol  binary_float_value,
  f.bindoublecol binary_double_value,
  f.charcol      char_value,
  f.varcharcol   varchar_value,
  f.ncharcol     nchar_value,
  f.nvarcharcol  nvarchar_value,
  f.datecol      date_value,
  f.ts_col       timestamp_value,
  f.tswtz_col    timestamp_with_time_zone_value,
  l.blobcol      blob_value,
  l.clobcol      clob_value,
  l.nclobcol     nclob_value
  from
  (select * from radm_fptm$ order by fpver desc) f,
  (select * from radm_fptm_lob$ order by fpver desc) l
  where rownum=1

View Text - HTML Formatted

SELECT F.NUMBERCOL NUMBER_VALUE
, F.BINFLOATCOL BINARY_FLOAT_VALUE
, F.BINDOUBLECOL BINARY_DOUBLE_VALUE
, F.CHARCOL CHAR_VALUE
, F.VARCHARCOL VARCHAR_VALUE
, F.NCHARCOL NCHAR_VALUE
, F.NVARCHARCOL NVARCHAR_VALUE
, F.DATECOL DATE_VALUE
, F.TS_COL TIMESTAMP_VALUE
, F.TSWTZ_COL TIMESTAMP_WITH_TIME_ZONE_VALUE
, L.BLOBCOL BLOB_VALUE
, L.CLOBCOL CLOB_VALUE
, L.NCLOBCOL NCLOB_VALUE FROM (SELECT *
FROM RADM_FPTM$ ORDER BY FPVER DESC) F
, (SELECT *
FROM RADM_FPTM_LOB$ ORDER BY FPVER DESC) L
WHERE ROWNUM=1