| 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: 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_01C07755.86FA2970
Content-Type: text/plain;
charset="iso-8859-1"
Good one, Mohan.
Alex
-----Original Message-----
From: Mohan, Ross [mailto:MohanR_at_STARS-SMI.com]
Sent: Friday, January 05, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Subject: OT RE: Database design dilemma - not null vs nullable
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 - 14:24:31 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_01C07755.86FA2970 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.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D417542120-05012001>Good=20 one, Mohan. </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D417542120-05012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D417542120-05012001>Alex</SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><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 2:51=20 PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> OT=20 RE: Database design dilemma - not null vs = nullable<BR><BR></DIV></FONT> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>Lisa, </FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>Aren't you clever, telling the truth like that! I like = it when=20 you talk turkey. </FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial size=3D2>Then=20 I know </FONT></SPAN><SPAN class=3D908564419-05012001><FONT = color=3D#0000ff=20 face=3DArial size=3D2>exactly what you are thinking, nothing at all = like the=20 gentle </FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>exchanges </FONT></SPAN><SPAN = class=3D908564419-05012001><FONT=20 color=3D#0000ff face=3DArial size=3D2>between Alex and Rachel,=20 viz:</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>ALEX: I think we don't need this on the list.=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>RACHEL: <sound of Thesaurus being thrown> Oh,=20 yeah?</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>ALEX: < sound of Thesaurus hitting it's target > = Ouch!!</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>RACHEL: Thank your lucky stars I used my bad = arm!</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>ALEX: Ok, I give up. For now. </FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>ERIC: Have you reviewed the heliocentric = dialectric=20 kool-aid acid test</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001> <FONT=20 color=3D#0000ff face=3DArial size=3D2>for hegemonist cognitive = imperialists? Here's=20 a web site to google</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=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 color=3D#0000ff = face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial size=3D2>..et=20 cetera, et alia....</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001></SPAN><SPAN=20 class=3D908564419-05012001><FONT color=3D#0000ff face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial 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 color=3D#0000ff = face=3DArial=20 size=3D2>stiff. Have a scotch for me!</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial size=3D2>See=20 you next week!</FONT></SPAN></DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D908564419-05012001><FONT color=3D#0000ff = face=3DArial=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 color=3D#0000ff face=3DArial 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=20 can't wait to be bored stiff at home tonight (whooppee). I = really feel=20 that Eric Pierce is the most far out person on this list with his = wild views=20 of 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=20 in the same office as you, I'm sure there would never be a boring = day. =20 I also really feel there is more to life than = this.</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT><FONT color=3D#0000ff = face=3DArial=20 size=3D2><SPAN = class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001>OK. There I said it. =
</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001>Siv, to convince them otherwise, you may = want to=20 put together an estimate of how much wasted space they will = use. =20 Usually when mgmt sees $$ attached to an opinion they pay = attention.=20 </SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001>Have a great weekend = everyone!</SPAN></FONT></DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20 class=3D826001819-05012001></SPAN></FONT> </DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><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=20 1:50 PM<BR><B>To:</B> Multiple recipients of list=20 ORACLE-L<BR><B>Subject:</B> RE: Database design dilemma - not = null vs=20 nullable<BR><BR></DIV></FONT> <DIV><SPAN class=3D236194718-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2>Lisa, don't mince words. Tell us how you really=20 feel.</FONT></SPAN></DIV> <DIV><SPAN class=3D236194718-05012001><FONT color=3D#0000ff = face=3DArial=20 size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D236194718-05012001><FONT color=3D#0000ff = face=3DArial=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 = [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=20 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,=20 which we will ultimately inherit for maintenance. They = are porting=20 this application from a different database platform to Oracle, = since we=20 are an Oracle shop. They have decided to make every = column in=20 every table a NOT NULL column. They want to implement = default=20 values at the database level for every column (' ', 0 and some = low date=20 for varchar2, number and date) and then let the application = validate and=20 enforce significant data as required. I am looking for = opinions on=20 the pros and cons of this type of approach, both from a = database and=20 application 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 href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A></FONT> <BR><FONT = size=3D2>--=20 </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=20 E-Mail message</FONT> <BR><FONT size=3D2>to: = ListGuru_at_fatcity.com (note=20 EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT = size=3D2>the message=20 BODY, include a line containing: UNSUB ORACLE-L</FONT> =
 |
 |