ALL_CONSTRAINTS and NOT NULL columns

Hi all,

I have been searching the Oracle 10 docs, but cannot find an answer to this question.

Is there a way to know that a row in ALL_CONSTRAINTS of type C (check constraint) is "only" a NOT NULL constraint on a column instead of a user written check constraint?

I have been experimenting, but it seems that ALL_CONS_COLUMNS always returns columns involved in the check constraint text and that for "not null" constraint, the constraint text is always: "<column_name>" IS NOT NULL

But is that really the only way?

-- 
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com