Need to add values into existing rows and columns
oracle, sql
Solution
Assuming firstname+lastname is unique:
update CUSTOMERS
set ORDER_PRICE = 4.7
where FIRST_NAME = 'The' and LAST_NAME = 'Dude'
update CUSTOMERS
set ORDER_PRICE = 4.2
where FIRST_NAME = 'Big' and LAST_NAME = 'Lebowsky'
...
Problem
I have a table called CUSTOMERS with 5 columns and 3 rows: LAST_NAME, FIRST_NAME, ADDRESS, CITY, ORDER_PRICE and I keep screwing it up and having to delete new rows I create because I'm unsure how to insert into the ORDER_PRICE column, values for rows 1 2 and 3. i've tried insert into, update table clauses but i'm doing something wrong. Can anyone tell me how to insert values into rows 1, 2, & 3 or column ORDER_PRICE? ORDER_PRICE is of sata type NUMBER Thanks