求教：在oracle中，怎么从一张表把数据导入另一张表。 [复制链接]

电梯直达

1楼 [收藏(0)] [报告]

发表于 2006-03-02 19:15 |只看该作者 |倒序浏览

在oracle中，怎么从一张表把数据导入另一张表。表结构不同，有没有类似这样的sql：

insert into xx(aa, bb) from (select aa, bb from yy)

2楼 [报告]

发表于 2006-03-02 20:16 |只看该作者

steven@SCARF.US.ORACLE.COM> drop table a;

Table dropped.

steven@SCARF.US.ORACLE.COM> create table a (col1 number, col2 varchar2(20),col3 varchar2(20));

Table created.

steven@SCARF.US.ORACLE.COM> insert into a values (1,
  2  'name','value');

1 row created.

steven@SCARF.US.ORACLE.COM> commit;

Commit complete.

steven@SCARF.US.ORACLE.COM> create table b (col1 number, col2 varchar2(20));

Table created.

steven@SCARF.US.ORACLE.COM> insert into b (col1, col2) select col1, col2 from a;

1 row created.

steven@SCARF.US.ORACLE.COM> commit;

Commit complete.

steven@SCARF.US.ORACLE.COM> select * from b;

   COL1 COL2
---------- --------------------
      1 name

steven@SCARF.US.ORACLE.COM> spool off;