Prior Table Table TESTTABLEX Next Table

Columns of Table TESTTABLEX
Column ID Column Name Datatype Not Null Data Default Comments
1 COLUMN11 VARCHAR2(4000 BYTE) Y 'abcd'  
2 COLUMN2 VARCHAR2(4000 BYTE) Y    
3 COLUMN32 DATE Y    
4 COLUMN43 INTEGER Y 1  
5 COLUMN5 CLOB Y    

Indexes on Table TESTTABLEX
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE TESTTABLEX_PK NORMAL COLUMN1, COLUMN3, COLUMN4 <none>        

PK, UK, & Check Constraints on Table TESTTABLEX
Constraint Name Type Condition Status Columns
SYS_C0031266 Check "COLUMN1" IS NOT NULL ENABLED COLUMN1
SYS_C0031267 Check "COLUMN2" IS NOT NULL ENABLED COLUMN2
SYS_C0031268 Check "COLUMN3" IS NOT NULL ENABLED COLUMN3
SYS_C0031269 Check "COLUMN4" IS NOT NULL ENABLED COLUMN4
SYS_C0031270 Check "COLUMN5" IS NOT NULL ENABLED COLUMN5
TESTTABLEX_PK Primary Key   ENABLED COLUMN1, COLUMN3, COLUMN4

Table TESTTABLEX does not have...
Comments
Partitions
Foreign Key Constraints
Redaction Policies