It depends on how the application is coded. ' ' = ' ',
0 = 0 (except in Ada :) and '04-JAN-1654' =
'04-JAN-1654', but NULL <> NULL. Or if the application
bombs out when it hits a null value, then....
You're right though, from a DB design POV, that's
pretty wasteful, and will be nasty to maintain should
any data problems arise.
- "Koivu, Lisa" <lkoivu_at_qode.com> wrote:
> 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-----
> Sent: Friday, January 05, 2001 1:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
Received on Fri Jan 05 2001 - 12:51:45 CST
