Re: Check if value changed from Default value

Brian Tkatch wrote:
>
> 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

A quick hack would to use PL/SQL to select the long into a varchar to enable the check

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."