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: Creating Table as select...

Re: Creating Table as select...

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sun, 08 Feb 2004 13:32:12 +0100
Message-ID: <c059kl$d7h$1@news1.tilbu1.nb.home.nl>


Mark C. Stock wrote:
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1076170588.168313_at_yasure...
> | hrishy wrote:
> |
> | > Hi Daniel
> | >
> | > Can you please exaplin me why..that i should prefer unique constraints
> | > over unique indexes.
> | >
> | > regards
> | > Hrishy
> |
> | Can't defer unique index ... can defer unique constraint
>
> excellent point -- it's interesting how often the ability to defer
> constraints makes coding much, much simpler
>
> -- mcs
>
>
>

And almost a must-have when doing updatable replication, I'd like to add

-- 

Regards,
Frank van Bortel
Received on Sun Feb 08 2004 - 06:32:12 CST

Original text of this message

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