oracle insert语句的扩展(二)

2014-11-24 12:32:47 · 作者: · 浏览: 1
* from sales www.2cto.com
create table cow_sales(year_sales number)
insert all
into cow_sales values(year_2008)
into cow_sales values(year_2009)
into cow_sales values(year_2010)
into cow_sales values(year_2011)
into cow_sales values(year_2012)
select * from sales
select * from cow_sales