Add a column to a table with check constraint SQL

Question

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"

peterm · Accepted Answer · 2014-02-04 04:04:01Z

7

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

edited Feb 4, 2014 at 4:04

answered Feb 4, 2014 at 3:58

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Next_Line_Nick Over a year ago

That solved it thanks for your help and patience with my lack of knowledge

Collectives™ on Stack Overflow

Add a column to a table with check constraint SQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related