Re: NULLS with ORACLE
From: Rick Rutt <rrutt_at_delphi.com>
Date: 1995/08/01
Message-ID: <xfMg5dj.rrutt_at_delphi.com>#1/1
Date: 1995/08/01
Message-ID: <xfMg5dj.rrutt_at_delphi.com>#1/1
Anthony Foo <apxafoo_at_technet.sg> writes:
>I had tried altering the table with the column set as NOT NULL DEFAULT SPACES
>but Oracle return telling me I can't set the column as such. It's either I set
>the column as NOT NULL or I accept NULL with default.
Perhaps a Before-Insert trigger can test each column for a null value, and change it to your preferred default value. The trigger might become verbose, but your PowerBuilder applications will be simpler.
- Rick --
(Rick Rutt is a system architect living and working in Midland, Michigan.) Received on Tue Aug 01 1995 - 00:00:00 CEST