I don't understand how column "ALL_CONSTRAINTS.CONSTRAINT_NAME" value is generated, can you explain? See example-value (SYS_C0054966) below.
--TABLE
CREATE TABLE Test1
(
Name1 VARCHAR2(100 CHAR),
Name2 VARCHAR2(100 CHAR) NOT NULL,
Name3 VARCHAR2(100 CHAR) NULL
);
select * from user_constraints
where table_name = 'TEST1';
CONSTRAINT_NAME.............SEARCH_CONDITION
SYS_C0054966...................."NAME2" IS NOT NULL
(I went into web page called http://www.lycos.com/ and entered search phrase "oracle ALL_CONSTRAINTS CONSTRAINT_NAME sequence" but it didn't find any good explanatory links. then i searched un-successfully in a we page called "Google" too, the result was the same- i didn't find answer for my question. Also i looked into Documentation http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_1037.htm#i1576022 but as always documentation was poor and didn't help either. so i thought to ask from Forum.)
Edited by: CharlesRoos on Jul 8, 2010 6:08 AM