Alter Command

[Holly13]

I need to alter a column in a table by the type so that the price is reduced by 3%. Can anyone give me any ideas on how to do this.

SQL> ALTER TABLE FICTION
2 MODIFY (PRICE)
3 WHERE PUBLISHER_CODE = 'PE' AND
4 HAVING (SUM(PRICE * .03)-PRICE)
5 ORDER BY PRICE;
This is what I have but it gives me an error message.
Thanks

[michaelb]

I have to guess that what you really want here is not to alter the table, but to change some values.

If this is the case, you could use something like this:

UPDATE TABLE FICTION SET PRICE = PRICE * 0.97
WHERE PUBLISHER_CODE = 'PE';
 

[debasisdas]

If u want to change the value why u need to alter
Alter is a DDL. It is only used to change the structure not the data.
Since your requirment is to change data not structure use the simple update command

SQL>UPDATE TABLE FICTION SET PRICE = PRICE * 0.97
WHERE PUBLISHER_CODE = 'PE' ;.