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
Your solution looks almost correct, but there is a small mistake in your ALTER TABLE statement. Here is the corrected version:
1. First, execute the ALTER TABLE statement to add the 'Status' column with the data type VARCHAR2(30):
```
ALTER TABLE Orderlines
ADD Status VARCHAR2(30);
```
2. Next, execute the UPDATE statement to set the Status as 'Completed' for OrderID = 214011:
```
UPDATE Orderlines
SET Status = 'Completed'
WHERE OrderID = 214011;
```
3. Finally, you can check the updated records by executing the SELECT statement:
```
SELECT *
FROM Orderlines;
```
This will display all the rows in the Orderlines table, including the newly added 'Status' column and updated values.