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: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sat, 7 Feb 2004 12:30:35 -0500
Message-ID: <iPednRANe4p3vbjdRVn-jg@comcast.com>

"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

Received on Sat Feb 07 2004 - 11:30:35 CST

Original text of this message

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