Question

Add the not null constraint in the product_master table with the columns description, profit percent, sell price and cost price.

Answer 1

Alter table product_master

           modify(description varchar2(15) constraint con1 NOT NULL)

           modify(profit percent number(4,3) constraint con2 NOT NULL)

           modify(sell price number constraint con3 NOT NULL)

           modify(cost price number constraint con4 NOT NULL)