SYS_NC00是一种系统自动生成的辅助列,在Oracle 12c以后大量出现在用户表中,其主要伴随一下这些功能出现:
row archival;
create index t_i on t(upper(v)); 函数索引
alter table xxx add (b integer default 1); default 值
property:
0x0008 = virtual column(old)
0x0020 = hidden column(old)
0x00010000 = expression column(new)
default$: is overloaded to store index expression
name: is system generated. It is SYS_NC<5 digit intcol#>$
SYS_C000$ 伴随以下功能出现:
各种未指定名字的约束
CONSTRAINT constraint_name
Specify a name for the constraint. If you omit this identifier, then Oracle Database generates a name with the form SYS_Cn. Oracle stores the name and the definition of the integrity constraint in the USER_, AL