Oracle点滴
摘要:复制表,包括表结构create table TACE_TRAFFIC_HUB as select * from TACE_TRAFFIC_HUB1复制表中数据,表结构存在insert into TACE_TRAFFIC_HUB select * from TACE_TRAFFIC_HUB1修改表结构alter table pnr_path add (dep_city VARCHAR2(3), arr_city VARCHAR2(3))alter table pnr_path rename column city to dep_cityalter table pnr_path modify de
阅读全文
posted @ 2012-09-14 10:11
浙公网安备 33010602011771号