Re: Check if value changed from Default value

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 28 Sep 2001 15:16:25 GMT
Message-ID: <3bb49409.3284546250@news.alt.net>

How? I was thinking along the line of TO_LOB and then DBMS_LOB.SubStr. I'm assuming there is an easier way.

Brian

On Wed, 26 Sep 2001 19:05:29 +0100, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>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..."
Received on Fri Sep 28 2001 - 10:16:25 CDT