Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for a way to implement SQL-92 Domain
Following up on Hans Forbrich, 25 Mar 2003:
> - ability to add domains as required (Create 1 domain that contains the
> list of domains. Do not enforce integrity on this)
Yes!!! Same here.
> - simpler maintenance, especially when there are 200+ domains
Yupper...
> - lookup code can be automatically generated,
> - it's consistent
>
Bingo!
> Biggest reason for not doing this - all that wasted disk space (Actually
> that could be a bogus argument - what's the space required for 100
> indexed tables with 2-10 rows each & avg. row length of 50 bytes?)
>
Precisely.
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospamReceived on Tue Mar 25 2003 - 03:51:05 CST