Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Check if value changed from Default value
Just before I was trying to find out if the value from a column was
changed from its default. The column is a VARCHAR2. Defaults (in
ALL_TAB_COLUMNS) are in Data_Default, which is a LONG. Is there a way
to do the comparison.
Something like
SELECT
Moo
FROM
Cow
WHERE
Moo <> (SELECT Data_Default FROM User_Tab_Columns WHERE Table_Name = 'COW' AND Column_Name = 'MOO');
Brian Received on Tue Sep 25 2001 - 15:59:34 CDT