这张日期维度表,怎么用存储过程循环插入,日期增加到2030年 select date '2016-06-29' + rownum - 1 ddate, trunc(trunc(date'2016-06-29' + rownum - 1),'mm') monstart, trunc(last_day(date'2016-06-29' + rownum - 1)) monend from dualconnect by rownum < date '2030-12-31' - date '2016-06-29' + 1; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table test(ddate date, monstart date, monend date);insert into test(ddate, monstart, monend)select date '2016-06-29' + rownum - 1 ddate, trunc(trunc(date'2016-06-29' + rownum - 1),'mm') monstart, trunc(last_day(date'2016-06-29' + rownum - 1)) monend from dualconnect by rownum < date '2030-12-31' - date '2016-06-29' + 1; 也可以换成level的形式。create table test(dtime date, dt_start date, dt_end date); insert into test(dtime, dt_start, dt_end)with tmp as(select to_date('2016-06-29','yyyy-mm-dd') dtime from dual)select dtime + level - 1 dtime, trunc(trunc(dtime)+ level - 1,'mm') dt_start, trunc(last_day(dtime+ level - 1)) dt_end, from tmpconnect by level <= date '2030-12-31' - dtime + 1; 怎么在网页中登录oracle 11g数据库 Oracle中如何根据一张表中的一条记录更新另一张表中的多条记录 用sqlserver2000将oracle的表空间直接导入到sqlserver 中 pl/sql developer的一个问题 请教oracle问题... 这个问题困惑了我一天,如何用SQL语句实现? 问一个关于sql语句查询的问题!急! 关于进销存软件的建库问题 oracle用户登陆时出错,请帮忙! tnsnames.ora中的LISTENER_ORCL是做什么用? Oracle查询思路-语句分析 centOS安装oracle 报这个错误是什么意思??
create table test(ddate date, monstart date, monend date);insert into test(ddate, monstart, monend)
select date '2016-06-29' + rownum - 1 ddate,
trunc(trunc(date'2016-06-29' + rownum - 1),'mm') monstart,
trunc(last_day(date'2016-06-29' + rownum - 1)) monend
from dual
connect by rownum < date '2030-12-31' - date '2016-06-29' + 1;
create table test(dtime date, dt_start date, dt_end date);
insert into test(dtime, dt_start, dt_end)
with tmp as
(select to_date('2016-06-29','yyyy-mm-dd') dtime from dual)
select dtime + level - 1 dtime,
trunc(trunc(dtime)+ level - 1,'mm') dt_start,
trunc(last_day(dtime+ level - 1)) dt_end,
from tmp
connect by level <= date '2030-12-31' - dtime + 1;