Nulls

From: Mark Parssey <markpa_at_delm.tas.gov.au>
Date: 1997/10/01
Message-ID: <01bcce3c$93a428e0$ad0b6d93@l8ip173.delm.tas.gov.au>#1/1

As an Oracle newbie I'm just creating my first db & application.

Past practice for us as an Ingres site has been to set the non reqd. fields to NOT NULL WITH DEFAULT. This ensured that fields where either 0 or blank, depending on type.

This then meant searches had no problems with null fields & you didn't have to do thinks like search for both is null & = ''.

This approach doesn't seem appropriate for Oracle as it would/did cause problems when leaving non-required fields empty on the form.

I have amended the fields to allow null but will I now have a prob. with searches as above.

I would appreciate advice on the best way of defing my tables. Also how can I execute a query to find empty fields? Received on Wed Oct 01 1997 - 00:00:00 CDT