Two table structure: RINGLIB3 RINGID VARCHAR2 (20) SONGNAME VARCHAR2 (50) SINGER VARCHAR2 (50) PROVIDER VARCHAR2 (20) RINGPRICE VARCHAR2 (10) RINGLIB RINGID VARCHAR2 (20) SONGNAME VARCHAR2 (50) SINGER VARCHAR2 (50) PROVIDER VARCHAR2 (20 ) rINGPRICE NUMBER using insert into ringlib select * from ringlib3 fail to realize increased data into the table ringlib, prompt "data error" with insert into ringlib select ring, songname, singer, provider, to_number (ringprice) from ringlib3 fail to realize increased data into the table ringlib And also prompt "Data Error". Finally, it is a problem with the possible data provided by the price (Ringprice), and the original price has a decimal point (1.0, 1.5, 2.0). Finally, use SELECT MAX (RINGPRICE) from Ringlib3, there is a Chinese word in the price field, such as "Rolling Stone Mobile". Finally, find them (Select * from Ringlib3 WHERE Ringprice Not Like '%.%), Updating their price to 0.
