使用Oracle8i查询

Question

如何使用Oracle8I将table1中的数据输出到table2中？ 我使用的是Aqua Data Studio 7.5，后端是Oracl8i。

表 1：

Name              Prods Cus_id
Mark              Rice  87311870
Judy              Rice  87364239
Judy              Bowl  87364239
Tom               Apple 87404026
Tom               Milk  87404026
Tom               Coffee    87404026
Smith             Peanut    87500245
Smith             Tea   87500245
Ortiz             Egg   87569724
Ortiz             Cheese    87569724
Ortiz             Pizza 87569724
Ortiz             Pepper    87569724
Hunt              Chips 87570092

表 2：

Name        Prod1       Prod2       Prod3       Prod4   Cus_id
Mark        Rice                            87311870
Judy        Rice        Bowl                    87364239
Tom Apple   Milk        Coffee          87404026
Smith       Peanut      Tea                 87500245
Ortiz       Egg     Cheese      Pizza       Pepper  87569724
Hunt        Chips                           87570092

Answer 1

请参阅此示例：

set feedback off;
set pagesize 0;

create table foo (a number, b varchar(10), c varchar(10));

insert into foo values ( 15, 'abc','def' );
insert into foo values (998, 'max','min' );
insert into foo values (  7, 'bla','bla' );
insert into foo values (632, 'now','then');

insert into foo 
  (a,b,c)
  (select                   AA,
                            BB,
                            CC 
  from
    (select max(a) +1       AA      from foo), 
    (select 'new'           BB,
            'old'           CC      from dual));

select * from foo where a = (select max(a) from foo);

drop table foo;

来源：Oracle SQL：使用 Select 插入