Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Check if value changed from Default value

Check if value changed from Default value

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 25 Sep 2001 20:59:34 GMT
Message-ID: <3bb0ef38.3045745578@news.alt.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US