Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for a way to implement SQL-92 Domain

Re: Looking for a way to implement SQL-92 Domain

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: 25 Mar 2003 09:51:05 GMT
Message-ID: <Xns9349D16898340Tokenthis@210.49.20.254>


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.nospam
Received on Tue Mar 25 2003 - 03:51:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US