随笔分类 -  Database

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 究生 阅读(321) 评论(0) 推荐(0)

导航