Im supposed to add the column Status to the Orderlines table. Its data type is VARCHAR2(30). After adding the column. i need to update the table. If OrderID is 214011, its status will be "Completed". Would like to someone to see if my solution is correct i think i am missing something.
my solution
Rem Alter Table Orderlines
Alter Table Orderlines
Add status VARCHAR2(30);
Describe Orderlines;
Rem Update Orderlines
Update Orderlines
set Status = 'Completed'
where OrderID = 214011;
Select *
from Orderlines