Kbase P74887: What is sys_nc#####$ column in Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/9/2004 |
|
Status: Unverified
GOAL:
What is sys_nc#####$ column in Oracle
GOAL:
What is sys_nc columns in Oracle?
GOAL:
Why are sys_nc columns created in Oracle?
GOAL:
How do I see sys_nc columns in Oracle?
FIX:
When a function based index is created, oracle creates a hidden column on a base
table. Oracle creates this column as COL# as 0 and NAME as SYS_NC<Oracle Assign
Number>$.
DBA_IND_EXPRESSIONS can be referenced to to see what function was used to define the index.