For the given relation, what should be the query to change the data type of P_Price so that it can hold decimal numbers?
|
PRODUCT |
|
P_Id P_Name P_Price P_Type |
1
ALTER TABLE PRODUCT MODIFY P_Price DOUBLE;
2
ALTER PRODUCT MODIFY DATATYPE P_Price FLOAT;
3
ALTER PRODUCT TABLE MODIFY DATATYPE P_Price DOUBLE;
4
ALTER TABLE PRODUCT MODIFY P_Price FLOAT;