| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database design dilemma - not null vs nullable
Could be worse...they could decide that they should use CHAR instead of
VARCHAR under the pretense of eliminating potential fragmentation problems.
:) (and I have seen this in a vendor database...rough calculations said it
would have required 1/7th the amount of disk space if they would have used
varchars and allowed nulls)
:)
Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Friday, January 05, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database design dilemma - not null vs nullable
What a waste of disk space! Storing spaces instead of leaving a column null? Sounds like storing a bunch of useless garbage to me.
-----Original Message-----
From: Siv Chelakkara [mailto:Siv.Chelakkara_at_3cc.co.wayne.mi.us]
Sent: Friday, January 05, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Database design dilemma - not null vs nullable
Hi all,
We have an outside vendor developing an application, which we will
ultimately inherit for maintenance. They are porting this application from
a different database platform to Oracle, since we are an Oracle shop. They
have decided to make every column in every table a NOT NULL column. They
want to implement default values at the database level for every column ('
', 0 and some low date for varchar2, number and date) and then let the
application validate and enforce significant data as required. I am looking
for opinions on the pros and cons of this type of approach, both from a
database and application point of view.
Thanks,
Siv
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Siv Chelakkara
INET: Siv.Chelakkara_at_3cc.co.wayne.mi.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 05 2001 - 14:15:19 CST
 |
 |