读书人

Oracle复制表结构跟数据

发布时间: 2013-12-15 22:17:18 作者: rapoo

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;

?

?

读书人网 >其他数据库

热点推荐