Anil Kumar (Anilation)

Set Null/Not Null

If you are searching to find info regarding Not Null Constraint so that you can remove the not null constrain using sql, it is more than likely you will find help only on adding Not Null constraint to a oracle table, but if you want to remove the constraint, this will help :-)

The syntax to remove the null constraint from an oracle table is
ALTER TABLE < table name > MODIFY <column1 > NULL;

The syntax to add the constraing is (you will find everywhere) :
ALTER TABLE <table name > MODIFY <column1 >NOT NULL;

For other databases: Set Null/set not Null

To delete a multimedia column from Oracle database
Set the column to empty_blob() / empty_clob()

But there is a catch read more Deleting BLOB value from the database

Posted by Anilzown at March 15, 2004 02:48 PM