oracle插入数据并自动增加

Question

怎么从20130701至20130801的一百条数据，自增长添加到mete表的mete_id字段里面去呢，mete表一共三个字段，其他两个字段为空。

Answer 1

你试试

INSERT INTO mete (mete_id) 
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) + (SELECT MAX(mete_id) FROM mete) as new_mete_id
FROM generate_series('2013-07-01'::date, '2013-08-01'::date, '1 day') as date_sequence;