Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Two simple questions
Actually, the length of a column CAN be decreased, although it needs to be
empty to do this.
This can be accomplished by
dumping the primary key and the affected column in a temporary table,
update the column to empty,
altering the table,
and restoring the original data.
Regards,
Sybrand Bakker, Oracle DBA
<un2000_at_my-deja.com> wrote in message news:7mifjh$lmk$1_at_nnrp1.deja.com...
> 1. Length of the column can be increased but not decreased.
> 2. No. the new column will always be added at the end of the table.
>
>
> In article <378CAD5B.CF9FF2AF_at_netsec.net>,
> sam.petitto_at_netsec.net wrote:
> > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> > <html>
> > 1. can the originally specified length of a datatype be increased or
> decreased
> > after it is in use ?
> > <br>2. when inserting an additional column in a table, can the
> placement
> > within the order of columns be specified
> > <br> or does Oracle force it somewhere(first, last,
> etc.)
> > ?
> > <p>TIA
> > <br>--
> >
> <br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~
> > <br>Sam Petitto
> > <br>Database Engineer
> > <br><a href="http://www.netsec.net/">Network Security Technologies
> Inc.</a>
> > <br>(877)799.9380 Toll Free
> > <br>(703)561.0420 Local
> > <br>(703)561.0426 Fax
> >
> <br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~
> > <br>This electronic message contains information from Network Security
> > <br>Technologies, Inc or its affiliates, which may be confidential,
> > <br>proprietary or otherwise protected from disclosure. The
> information
> > is
> > <br>intended to be used solely by the recipient(s) named above for the
> > <br>purposes intended by the originator. If you are not an
> intended
> > <br>recipient, be aware that any review, disclosure, copying,
> distribution
> > <br>or use of this transmission or its contents is prohibited.
> If
> > you have
> > <br>received this transmission in error, please notify us immediately
> by
> > <br>telephone at (703) 561-0420, or by electronic mail at
> sales_at_netsec.net
> > <br> </html>
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jul 14 1999 - 12:52:16 CDT