Oracle newbie needs help - alter column ColdFusion
From: Ann <annterrell_at_home.com>
Date: 27 Jul 2001 16:25:15 -0700
Message-ID: <5e9eb3ff.0107271525.4fc54f2a_at_posting.google.com>
Date: 27 Jul 2001 16:25:15 -0700
Message-ID: <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:
(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
the datatype is nvarchar
ALTER COLUMN column_name new_data_type length
Received on Sat Jul 28 2001 - 01:25:15 CEST