Oracle SQL ALTER TABLE error -
i have code this:
alter table "vma_csdd" add constraint "vma_csdd_pk" primary key ("id") enable alter table "vma_csdd" modify ("id" not null enable) alter table "vma_csdd" modify ("csdd_name" not null enable) it gives me error:
alter table "vma_csdd" modify ("id" not null enable) ora-01735: invalid alter table option
how fix this?
option enable not correct column definition have add types
alter table "vma_csdd" modify ("id" int not null ) alter table "vma_csdd" modify ("csdd_name" varchar(100) not null )
Comments
Post a Comment