How can I ALTER COLUMN to NULL when the column in NOT NULL in Oracle

Question

How can I ALTER COLUMN to NULL when the column in NOT NULL in Oracle, with a sentence or script?

sorry, te correct are: "How can I ALTER COLUMN to NULL when the column IS NOT NULL in Oracle [...]" — Yalmar Chavarría, Jun 10 '15 at 19:20
I solved using "Alter table mytable modify column1 VARCHAR2(15) null;" — Yalmar Chavarría, Jun 10 '15 at 20:57

Bohemian · Answer 1 · 2015-06-10T23:17:16.463

1

To alter the column (assuming the current type is varchar2(100)):

alter table mytable modify column1 varchar2(100) null

Interestingly, this fails if the column is already nullable.

edited Jun 10 '15 at 23:17

answered Jun 10 '15 at 19:07

Bohemian

I solved using "Alter table mytable modify column1 VARCHAR2(15) null;" – Yalmar Chavarría Jun 10 '15 at 20:55

1 Answers1