May 27, 2016

Homework Help: Oracle

Posted by vsu1 on Tuesday, December 1, 2009 at 11:03pm.

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:

Related Questions

More Related Questions