Insert into... SELECT... statement in ORACLE syntax

Insert into... in ORACLE syntax... SELECT... statement to directly Insert the data in a table into another table 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'); www.2cto.com 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;
Author: taoxingtianxia