[DB/Oracle] NOT NULL ENABLE

 

NOT NULL = NOT NULL ENABLE 

NULL = NULL DISABLE

CREATE TABLE FOO (PRIORITY_LEVEL NUMBER DEFAULT 42 NOT NULL ENABLE); // Default
CREATE TABLE FOO (PRIORITY_LEVEL NUMBER DEFAULT 42 NOT NULL);
// NOT NULL ENABLE = NOT NULL

CREATE TABLE FOO (PRIORITY_LEVEL NUMBER DEFAULT 42 NOT NULL DISABLE);
CREATE TABLE FOO (PRIORITY_LEVEL NUMBER NULL);
// NOT NULL DISABLE = NULL

 

---

참고 및 출처 :

https://stackoverflow.com/questions/20595008/is-there-a-difference-between-not-null-and-not-null-enable

Is there a difference between "not null" and "not null enable"?

 

https://hello-nanam.tistory.com/11

오라클 테이블 생성 ( not null enable )