How can I ALTER COLUMN
to NULL when the column in NOT NULL in Oracle, with a sentence or script?
How can I ALTER COLUMN to NULL when the column in NOT NULL in Oracle
77 views Asked by Yalmar ChavarrÃa At
1
How can I ALTER COLUMN
to NULL when the column in NOT NULL in Oracle, with a sentence or script?
To alter the column (assuming the current type is
varchar2(100)
):Interestingly, this fails if the column is already nullable.