Add a column to a table with check constraint SQL

alter, constraints, oracle11g, sql

Solution

There is no `ADD COLUMN` clause in `ALTER TABLE` syntax. It's just `ADD`.

ALTER TABLE store101
ADD Base_salary NUMBER(7, 2) -- there is no need to add COLUMN clause
CONSTRAINT store101_Base_salary_ck 
CHECK (Base_salary > 0);

Here is SQLFiddle demo

Problem

I want to add a column to a table, then add a check constraint to make sure its greater than 0. I cant seem to get this to run in oracle sl developer. ``` Alter TABLE store101 add column Base_salary Number(7,2) constraint store101_Base_salary_ck check (Base_salary > 0); ``` Error report - SQL Error: ORA-00904: : invalid identifier 00904. 00000 - "%s: invalid identifier"

Original source