Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
Oracle supports a useful ALTER TABLE syntax that allows you to add / remove a NOT NULL constraint of a column wihile retaining the original datatype, i.e.
CREATE TABLE orders(order_id INTEGER NOT NULL PRIMARY KEY, customer_id INTEGER); |
ALTER TABLE orders MODIFY customer_id NOT NULL; |
This is rather useful in some cases.