Oracle复制表结构和数据
创建视图语法:create or replace view **_view as select * from **table;如:create or replace view v_connectivity_n asselect d_id ST_id, d_fno ST_fno, d_fid ST_fid, D_CURRENTSTATUS cd_dqzt, D_ELECTRICSTATE cd_sfdd, d_node1_id node1_id, d_node2_id node2_id, '1' ST_cid, '1' ST_cno from d_connectivity_n;删除视图语法:drop view **_view;
?
?