Monday
September 22, 2014

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:
Answer:

Related Questions

Oracle - I am supposed to do the following problem: Alter the s_ord table to add...
keybording and word processing - 7. to adjust a column's width in a table, you ...
PSY210 APPENDIX G - According to Sternberg, a person can experience eight ...
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 use ...
Microeconomics - 1. Complete Table-1 (Joseph Farms, Inc., Cost and Revenue Data...
English - I am ask to creat a table that lays out a day-by-day plan to use as a ...
chemistry - Reaction 1: I2(aq)Cu^+2(aq) Ag^+(aq)Br2(aq) Column 1---Column 2---...
Excel Filtering - Hi I'm trying to filter data between 3 different columns. I ...
Algebra - 1.What is the shape of the graph of any linear function? Answer-line 2...

Search
Members