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

No one has answered this question yet.

Answer this Question

Related Questions

sql - Write a SELECT statement that returns four columns based on the ...
third grade math - how do you check addition problems by adding up? Let's ...
PSY210 APPENDIX G - According to Sternberg, a person can experience eight ...
Oracle - I am supposed to do the following problem: Alter the s_ord table to add...
Information Technology - In the second column, list at least three processes (...
keybording and word processing - 7. to adjust a column's width in a table, ...
Access - A database has two tables named Products and Orders. The tables are ...
statistics - for some independent data using the mann whitney test group a has ...
stats - for some independent data using the mann whitney test group a has rank ...
Microeconomics - 1. Complete Table-1 (Joseph Farms, Inc., Cost and Revenue Data...

For Further Reading

First Name:
School Subject:
Answer: