Post a New Question

Oracle

posted by .

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

Answer This Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Post a New Question