PepperPart+2

Now we are going to add a column for Pepper Type (ptype), it will contain either 'Pepper or 'Extract'

ALTER TABLE peppers ADD ptype VARCHAR2(8)
 * Use the code below to add the type column


 * SELECT * FROM PEPPERS to make sure the column was added in.
 * Next we need to update all the rows that are there already as peppers. We can do this in one fell swoop with the UPDATE command

UPDATE peppers SET ptype='pepper' WHERE shu >= 0
 * Since all the peppers have a SHU that is greater than or equal to zero, we can just use that as our where condition
 * INSERT the Pepper Extracts from the website, be sure in include all three columns in your inserts
 * Show me your work for a grade

End Part 2