What datatypes are used by the Symantec DLP schema?
search cancel

What datatypes are used by the Symantec DLP schema?

book

Article ID: 160304

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

While Oracle is capable of supporting many different datatypes, the Symantec DLP schema makes use of  the following:

Environment

15.x

Resolution

SQL> select distinct data_type from dba_tab_columns where owner='PROTECT';

DATA_TYPE
--------------------------------------------------------------------------

TIMESTAMP(3)
LONG
TIMESTAMP(6)
FLOAT
NUMBER
CLOB
CHAR
DATE
VARCHAR2
BLOB