Re: Alter Table help
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 24 Jun 2001 22:34:05 -0700
Message-ID: <3B36CD4C.563A5E5A_at_exesolutions.com>
Date: Sun, 24 Jun 2001 22:34:05 -0700
Message-ID: <3B36CD4C.563A5E5A_at_exesolutions.com>
Peta Griffith wrote:
> When using this statement:
>
> ALTER TABLE sylogin.SERIAL ALTER COLUMN sylogin.USER_MESSAGE1 VARCHAR2
> (1000) DEFAULT ' ' NOT NULL
>
> we use the Oracle Provider and this error is returned:
>
> ORA-01735: invalid ALTER TABLE option
Where did you get the ALTER COLUMN syntax?
Were you looking for something more like this?
alter table lesson modify (col1 varchar2(8))
If not please describe what you are actually trying to accomplish and perhaps someone can help you.
Daniel A. Morgan Received on Mon Jun 25 2001 - 07:34:05 CEST