Add a column to a table with check constraint SQL
11,265
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
Author by
Next_Line_Nick
Updated on June 13, 2022Comments
-
Next_Line_Nick almost 2 years
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"
-
Next_Line_Nick about 10 yearsThat solved it thanks for your help and patience with my lack of knowledge