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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. third grade math

    how do you check addition problems by adding up?
  2. keybording and word processing

    7. to adjust a column's width in a table, you should?
  3. PSY210 APPENDIX G

    According to Sternberg, a person can experience eight general types of love. In the following table, a type of love as identified by Sternberg is in the left column. In the center column, write the combination of components that type …
  4. Oracle

    I am supposed to do the following problem: Alter the s_ord table to add a foreign key, CUSTOMER_ID, to the CUSTOMERID of the s_customer table. In addition, make sure ORD_ID of the s_item table is a foreign key to the ORDERID of the …
  5. sql

    Write a SELECT statement that returns four columns based on the InvoiceDate column of the Invoices table: • Use the CAST function to return the first column as data type varchar. • Use the CONVERT function to return the second …
  6. English

    You should mark the blank in the smile emoticon column if you like the activity. If you don't like an activity, you should check the box in the sad emoticon column. By doing that you should complete the table on the page. After you …
  7. Ed. Tech

    After creating a column heading and/or typing text within a column, what must you do to move text to the next column?
  8. Tech

    4. after creating a column heading and or typing text within a column what must you do to move text to the next column?
  9. Ed Tech

    4. After creating a column heading and/or typing text within a column, what must you do to move text to the next column?
  10. educational technology

    4. After creating a column heading and/or typing text within a column, what must you do to move text to the next column?

More Similar Questions