Re: Two simple questions

1.Yes. Example:

create table tab1 (col1 varchar2(80),col2 number(5)); alter table tab1 (col1 varchar2(132),col2,number(7,2));

2. It should always be placed last. If you look at the sys.all_tab_columns you'll understand why.

Ken

sam.petitto_at_netsec.net wrote:

> 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.) ?
>
>
Received on Thu Jul 15 1999 - 06:56:54 CDT