Table modify column nullable to not null.

 SELECT    'ALTER TABLE '

       || table_name

       || ' MODIFY ( '

       || :COLUMN_NAME

       || ' NOT NULL);'

  FROM user_tables

 WHERE table_name IN (SELECT DISTINCT table_name

                        FROM user_tab_cols

                       WHERE column_name = :COLUMN_NAME AND NULLABLE = 'Y');