DECLARE
CURSOR TEMP IS SELECT TABLE_NAME,COLUMN_NAME,DATA_LENGTH FROM USER_TAB_COLUMNS WHERE COLUMN_NAME='LAST_UPDATE' and NULLABLE='N' ;
STR VARCHAR2(100) := '';
BEGIN
FOR S IN TEMP LOOP
STR := 'ALTER TABLE '||S.TABLE_NAME||' MODIFY '||S.COLUMN_NAME||' date null';
DBMS_OUTPUT.PUT_LINE(STR);
EXECUTE IMMEDIATE STR ;
END LOOP;
END;
http://www.dedecms.com/knowledge/data-base/oracle/2013/0529/29113.html