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

Popular posts from this blog

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -