- 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.
- 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>...
- can the originally specified length of a datatype be increased or =
decreased after it is in use ?
- 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