Update Query:

update product set unit_price = 3000+100 where prod_no = '0001';

Select Query:

select * from product where prod_no =0001;

Output:

PROD_N DESCRIPTION          UNIT_PRICE QTY_ON_HAND CATEGORY
------ -------------------- ---------- ----------- ----------
0001   xxx                     3100           4       A

Subscribe to Posts | Subscribe to Comments

All Notes on BCA

My Notes Helps For BCA, MCA and IT Students. Site/Blog Designing by Pratik Badala