| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> OT RE: Database design dilemma - not null vs nullable
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07750.E3D26780
Content-Type: text/plain;
charset="iso-8859-1"
Lisa,
Aren't you clever, telling the truth like that! I like it when you talk
turkey.
Then I know exactly what you are thinking, nothing at all like the gentle
exchanges between Alex and Rachel, viz:
ALEX: I think we don't need this on the list.
RACHEL: <sound of Thesaurus being thrown> Oh, yeah?
ALEX: < sound of Thesaurus hitting it's target > Ouch!!
RACHEL: Thank your lucky stars I used my bad arm!
ALEX: Ok, I give up. For now.
ERIC: Have you reviewed the heliocentric dialectric kool-aid acid test
for hegemonist cognitive imperialists? Here's a web site to google
your eyes at: www.incomprehensible-arcanicity.com/this/that/whatever
..et cetera, et alia....
Oh, and as far as being bored stiff, it's better than being six feet under
and
stiff. Have a scotch for me!
See you next week!
Ross
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Friday, January 05, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database design dilemma - not null vs nullable
I liken the idea to storing a fundament of any kind in a database for sheets & giggles. I also think that Florida is highly overrated. I really feel that this Friday is going to be a lost day and evening and I can't wait to be bored stiff at home tonight (whooppee). I really feel that Eric Pierce is the most far out person on this list with his wild views of society that he shares with everyone and their stepbrother, and that you, Ross, are the clown, and you enjoy it immensely. I would love to work in the same office as you, I'm sure there would never be a boring day. I also really feel there is more to life than this.
OK. There I said it.
Siv, to convince them otherwise, you may want to put together an estimate of how much wasted space they will use. Usually when mgmt sees $$ attached to an opinion they pay attention.
Have a great weekend everyone!
-----Original Message-----
From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]
Sent: Friday, January 05, 2001 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database design dilemma - not null vs nullable
Lisa, don't mince words. Tell us how you really feel.
-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com]
Sent: Friday, January 05, 2001 1: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
<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.comReceived on Fri Jan 05 2001 - 13:51:26 CST
<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). ------_=_NextPart_001_01C07750.E3D26780 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: Database design dilemma - not null vs nullable</TITLE>
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>Lisa,=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>Aren't=20 you clever, telling the truth like that! I like it when you talk = turkey.=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>Then I=20 know </FONT></SPAN><SPAN class=3D908564419-05012001><FONT face=3DArial = color=3D#0000ff=20 size=3D2>exactly what you are thinking, nothing at all like the gentle=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>exchanges </FONT></SPAN><SPAN class=3D908564419-05012001><FONT = face=3DArial=20 color=3D#0000ff size=3D2>between Alex and Rachel, = viz:</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>ALEX: I think we don't need this on the list. =
</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>RACHEL: <sound of Thesaurus being thrown> Oh,=20 yeah?</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>ALEX:=20 < sound of Thesaurus hitting it's target > =20 Ouch!!</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>RACHEL: Thank your lucky stars I used my bad = arm!</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>ALEX:=20 Ok, I give up. For now. </FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>ERIC: Have you reviewed the heliocentric = dialectric kool-aid=20 acid test</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001> <FONT =
face=3DArial=20 color=3D#0000ff size=3D2>for hegemonist cognitive imperialists? Here's = a web site to=20 google</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2> your eyes at: <A=20 href=3D"http://www.incomprehensible-arcanicity.com/this/that/whatever">w= ww.incomprehensible-arcanicity.com/this/that/whatever</A></FONT></SPAN><= /DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>..et=20 cetera, et alia....</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001></SPAN><SPAN =
class=3D908564419-05012001><FONT=20 face=3DArial color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>Oh,=20 and as far as being bored stiff, it's better than being six feet under=20 and</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>stiff.=20 Have a scotch for me!</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff size=3D2>See=20 you next week!</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D908564419-05012001><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>Ross</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader><FONT face=3D"Times New Roman"=20 size=3D2>-----Original Message-----<BR><B>From:</B> Koivu, Lisa=20 [mailto:lkoivu_at_qode.com]<BR><B>Sent:</B> Friday, January 05, 2001 = 2:31=20 PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> RE:=20 Database design dilemma - not null vs nullable<BR><BR></FONT></DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN = class=3D826001819-05012001>I=20 liken the idea to storing a fundament of any kind in a database for = sheets=20 & giggles. I also think that Florida is highly = overrated. I=20 really feel that this Friday is going to be a lost day and evening = and I can't=20 wait to be bored stiff at home tonight (whooppee). I really = feel that=20 Eric Pierce is the most far out person on this list with his wild = views of=20 society that he shares with everyone and their stepbrother, and that = you,=20 Ross, are the clown, and you enjoy it immensely. I would love = to work in=20 the same office as you, I'm sure there would never be a boring = day. I=20 also really feel there is more to life than this.</SPAN></FONT></DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT><FONT face=3DArial = color=3D#0000ff=20 size=3D2><SPAN class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20 class=3D826001819-05012001>OK. There I said it. =
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN = class=3D826001819-05012001>Siv,=20 to convince them otherwise, you may want to put together an estimate = of how=20 much wasted space they will use. Usually when mgmt sees $$ = attached to=20 an opinion they pay attention. </SPAN></FONT></DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN = class=3D826001819-05012001>Have=20 a great weekend everyone!</SPAN></FONT></DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> Mohan, Ross=20 [mailto:MohanR_at_STARS-SMI.com]<BR><B>Sent:</B> Friday, January 05, = 2001 1:50=20 PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> RE:=20 Database design dilemma - not null vs nullable<BR><BR></DIV></FONT> <DIV><SPAN class=3D236194718-05012001><FONT face=3DArial = color=3D#0000ff=20 size=3D2>Lisa, don't mince words. Tell us how you really=20 feel.</FONT></SPAN></DIV> <DIV><SPAN class=3D236194718-05012001><FONT face=3DArial = color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D236194718-05012001><FONT face=3DArial = color=3D#0000ff size=3D2>-=20 Ross</FONT></SPAN></DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader><FONT face=3D"Times New Roman"=20 size=3D2>-----Original Message-----<BR><B>From:</B> Koivu, Lisa=20 [mailto:lkoivu_at_qode.com]<BR><B>Sent:</B> Friday, January 05, 2001 = 1:37=20 PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20 RE: Database design dilemma - not null vs = nullable<BR><BR></FONT></DIV> <P><FONT size=3D2>What a waste of disk space! Storing = spaces instead=20 of leaving a column null? Sounds like storing a bunch of = useless=20 garbage to me. </FONT></P><BR> <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From:=20 Siv Chelakkara [<A=20 = href=3D"mailto:Siv.Chelakkara_at_3cc.co.wayne.mi.us">mailto:Siv.Chelakkara@= 3cc.co.wayne.mi.us</A>]</FONT>=20 <BR><FONT size=3D2>Sent: Friday, January 05, 2001 1:21 PM</FONT> =
<BR><FONT
size=3D2>To: Multiple recipients of list ORACLE-L</FONT> =
<BR><FONT=20
size=3D2>Subject: Database design dilemma - not null vs = nullable</FONT>=20 </P><BR> <P><FONT size=3D2>Hi all,</FONT> </P> <P><FONT size=3D2>We have an outside vendor developing an = application, which=20 we will ultimately inherit for maintenance. They are = porting this=20 application from a different database platform to Oracle, since = we are an=20 Oracle shop. They have decided to make every column in = every table a=20 NOT NULL column. They want to implement default values at = the=20 database level for every column (' ', 0 and some low date for = varchar2,=20 number and date) and then let the application validate and = enforce=20 significant data as required. I am looking for opinions on = the pros=20 and cons of this type of approach, both from a database and = application=20 point of view. </FONT></P> <P><FONT size=3D2>Thanks,</FONT> </P> <P><FONT size=3D2>Siv</FONT> </P><BR> <P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Please see the = official=20 ORACLE-L FAQ: <A target=3D_blank=20 href=3D"http://www.orafaq.com">http://www.orafaq.com</A></FONT> =
<BR><FONT=20
size=3D2>-- </FONT><BR><FONT size=3D2>Author: Siv = Chelakkara</FONT> <BR><FONT=20 size=3D2> INET: Siv.Chelakkara_at_3cc.co.wayne.mi.us</FONT> =
</P>
<P><FONT size=3D2>Fat City Network Services -- = (858)=20 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20 California -- Public = Internet=20 access / Mailing Lists</FONT> <BR><FONT=20 = size=3D2>---------------------------------------------------------------= -----</FONT>=20 <BR><FONT size=3D2>To REMOVE yourself from this mailing list, = send an E-Mail=20 message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the = message BODY,=20 include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT =
 |
 |