Create table "schema"."mytable"(tableid number not null enable)
In the above sql statement, what does enable means?
what is the effect on this?
Thanks!
Printable View
Create table "schema"."mytable"(tableid number not null enable)
In the above sql statement, what does enable means?
what is the effect on this?
Thanks!
What do the docs say?
I don't know...
since I can just find Number not null without enable.
Please advise
Code:SQL> create table t1 (f1 number not null enable);
Table created.
SQL> create table t2 (f1 number not null disable);
Table created.
SQL> select table_name, constraint_name, constraint_type, status
2 from user_constraints;
TABLE_NAME CONSTRAINT_NAME C STATUS
------------------------------ ------------------------------ - --------
T1 SYS_C001568 C ENABLED
T2 SYS_C001569 C DISABLED
SQL> insert into t1 (f1) values (null);
insert into t1 (f1) values (null)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("MARIST89"."T1"."F1")
SQL> insert into t2 (f1) values (null);
1 row created.
SQL> commit;
Commit complete.
But default it is enable if I don't type Enable/Disable?
Try it and let us know.