select nullable from user_tab_columns where table_name='WORKDAYTYPE';
NU
--
Y
Y
Y
Y
Y
Y
Y
7 rows selected.
alter table WORKDAYTYPE modify CREATOR NOT NULL;
alter table WORKDAYTYPE modify CREATOR NOT NULL
*
ERROR at line 1:
ORA-01442: column to be modified to NOT NULL is already NOT NULL
desc WORKDAYTYPE
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID NUMBER(2)
IS_DELETED CHAR(1)
CREATOR VARCHAR2(96)
GMT_CREATE DATE
MODIFIER VARCHAR2(96)
GMT_MODIFIED DATE
DESCRIPTION VARCHAR2(192)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22034023/viewspace-683239/ ，如需转载，请注明出处，否则将追究法律责任。
