Re: Oracle newbie needs help - alter column ColdFusion

annterrell_at_home.com (Ann) wrote in message news:<5e9eb3ff.0107271525.4fc54f2a_at_posting.google.com>...
> I am needing to change the length of a field in an Oracle DB and need
> to know if altering an existing column is allowed. I am more familiar
> with SQL Server:
> the datatype is nvarchar
>
> (I am getting an Oracle Error Code = 1401
>
> ORA-01401: inserted value too large for column )
>
> Is something like the following possible? Can you give a real example
> of the syntax?
>
> ALTER TABLE table
> ALTER COLUMN column_name new_data_type length

alter table <table> modify (<columnr> <data_type>(<length>)

Please use the sql reference manual to avoid mere syntax questions in this group.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 30 2001 - 12:34:07 CEST