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: Number of Columns in a table.

Re: Number of Columns in a table.

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 06 Mar 2006 10:57:21 -0800
Message-ID: <1141671429.572087@jetspin.drizzle.com>


milind.namjoshi_at_trans.ge.com wrote:
> My primary Key is a composite key of 5 columns (22 bytes)
> With the Vertical/Long format it will be5+1, column repeated for all
> the attributes.
> I can not replace the PK with surrogate key as i want to use them for
> my start queries.
>
> Thanks

LONG? Long has been deprecated and has no place in a PK.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Mar 06 2006 - 12:57:21 CST

Original text of this message

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