Question: How do I alter a NOT NULL
column to allow NULL values for a column?
Answer: Oracle allows you to change a
table with a NOT NULL constraint to a NULL constraint with
an "alter table" statement.
If you try to insert a value into a table with a not null
column you will get a
First, example the constraints with the desc
SQL*Plus command:
SQL> desc invoice
Next, you can alter the table column to make it allow
NULL values:
alter table
invoice
modify
(mycol NULL);
