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 -> Spaces vs Null

Spaces vs Null

From: selvanm <selvanmNOseSPAM_at_hotmail.com.invalid>
Date: Tue, 30 Nov 1999 19:40:39 +1600
Message-ID: <2ae419f6.43ef40b8@usw-ex0108-062.remarq.com>


A file needs to be created from data in a table. Which of the following would be a better option and why:

  1. A field on a table which is madatory and part of a unique key. When the record is saved if the user did not enter a value default to spaces.
                          OR

An optional field as part of the unique key, and when the file is created set to spaces if no value.

Received on Mon Nov 29 1999 - 21:40:39 CST

Original text of this message

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