Altering the column datatype of an existing table 1

[Stretchwickster]

Hi,

I'm struggling to find the right syntax for enlarging a varchar2 column from 20 to 50 characters. There seem to be so many variations documented! At the moment I am using:

ALTER TABLE table_name ALTER COLUMN column_name VARCHAR2(50);

Your help would be much appreciated!

Clive

 

[sem]

Can you share those variations with us? The only one I know is

ALTER TABLE table_name MODIFY column_name VARCHAR2(50)

Regards, Dima

http://seminihin.narod.ru

 

[Stretchwickster]

Thank you very much - that works!

Other ways I saw on different sites were as follows:

ALTER TABLE table_name ALTER [COLUMN] column_name VARCHAR2(50);

or

ALTER TABLE table_name ALTER [COLUMN] column_name [TYPE] VARCHAR2(50);

Clive

 

[sem]

Can you post links to those sites?

Regards, Dima

http://seminihin.narod.ru