表print_media的press_release 為long類型
CREATE TABLE new_print_media (
product_id NUMBER(6),
ad_id NUMBER(6),
press_release CLOB);
INSERT INTO new_print_media
(SELECT p.product_id, p.ad_id, TO_LOB(p.press_release)
FROM print_media p);
CREATE TABLE new_print_media (
product_id NUMBER(6),
ad_id NUMBER(6),
press_release CLOB);
INSERT INTO new_print_media
(SELECT p.product_id, p.ad_id, TO_LOB(p.press_release)
FROM print_media p);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货