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: Two simple questions

Re: Two simple questions

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 14 Jul 1999 21:40:51 -0400
Message-ID: <_Raj3.174$w3.278@news.ipass.net>

  1. Yes and yes. The column length for most data types can be easily = increased. It can be decreased as well, but the column has to be empty = (NULL) to decrease it. (You can create a copy of the column as another = table, set the column to NULL, decrease it's length, then use a = correlated subquery to update the modified column from the original if = the data will still fit.) Look up the ALTER TABLE statement in the = Oracle documentation.
  2. No. When you add a column, Oracle will always place at the end of = the table. Who cares where the column physically is anyway? Just = select the columns in the order than you want, or build a view over the = table that reorders the columns.

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

    sam.petitto_at_netsec.net wrote in message = <378CAD5B.CF9FF2AF_at_netsec.net>...

  1. can the originally specified length of a datatype be increased or = decreased after it is in use ?
  2. when inserting an additional column in a table, can the placement = within the order of columns be specified or does Oracle force it somewhere(first, last, etc.) ? TIA -- =
    Sam Petitto Database Engineer Network Security Technologies Inc.
    (877)799.9380 Toll Free
    (703)561.0420 Local
    (703)561.0426 Fax
    =
    This electronic message contains information from Network Security Technologies, Inc or its affiliates, which may be confidential, proprietary or otherwise protected from disclosure. The information = is intended to be used solely by the recipient(s) named above for the purposes intended by the originator. If you are not an intended recipient, be aware that any review, disclosure, copying, = distribution or use of this transmission or its contents is prohibited. If you = have received this transmission in error, please notify us immediately by =

    telephone at (703) 561-0420, or by electronic mail at = sales_at_netsec.net        Received on Wed Jul 14 1999 - 20:40:51 CDT

Original text of this message

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