动态建立表,说有错误,知道帮帮忙 insert into myTable(myDate)values(to_date('2003/01/01','yyyy/mm/dd')) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SQL> create table date_temp 2 (mydate date);Table created.SQL> CREATE OR REPLACE procedure ins_date_by_year(p_year varchar2) 2 is 3 w_end_date date := to_date('12/31/'||p_year,'mm/dd/yyyy'); 4 w_start_date date := trunc(w_end_date,'y'); 5 begin 6 for i in 1 .. w_end_date - w_start_date + 1 loop 7 insert into date_temp values (w_start_date+1); 8 end loop; 9 end ins_date_by_year; 10 /Procedure created.SQL> select count(*) from date_temp; COUNT(*)---------- 0SQL> exec ins_date_by_year('2003')PL/SQL procedure successfully completed.SQL> select count(*) from date_temp; COUNT(*)---------- 365上面是用了一个循环,可以直接用一句sql完成:insert into date_tempselect to_date('1/1/2003','mm/dd/yyyy')+rownum-1 from all_objectswhere rownum <= to_date('12/31/2003','mm/dd/yyyy')- to_date('1/1/2003','mm/dd/yyyy') +1; 两张表的最大值查寻SQL语句 oracle 插入数据怎么报错啊??? 如何查询这样的数据? PC编译问题:ld: Unsatisfied symbol "sqlcxt" in file xxxx oracle 数据恢复 我在安装oracle client的管理员安装时 碰到了这样一个问题 谢谢了 通訊通道上出現 EOF?是什麼問題? 请教调oracle9i的联机帮助怎么用? 能否在ERwin中设定值自动增加的字段? oracle存储过程求优化到1s以下 怎么把一年中每一天的日期、所在第几星期插入数据库中啊?? oracle错误代码ora-01013用户取消操作是怎么回事?
2 (mydate date);Table created.SQL> CREATE OR REPLACE procedure ins_date_by_year(p_year varchar2)
2 is
3 w_end_date date := to_date('12/31/'||p_year,'mm/dd/yyyy');
4 w_start_date date := trunc(w_end_date,'y');
5 begin
6 for i in 1 .. w_end_date - w_start_date + 1 loop
7 insert into date_temp values (w_start_date+1);
8 end loop;
9 end ins_date_by_year;
10 /Procedure created.SQL> select count(*) from date_temp; COUNT(*)
----------
0SQL> exec ins_date_by_year('2003')PL/SQL procedure successfully completed.SQL> select count(*) from date_temp; COUNT(*)
----------
365上面是用了一个循环,可以直接用一句sql完成:
insert into date_temp
select to_date('1/1/2003','mm/dd/yyyy')+rownum-1 from all_objects
where rownum <= to_date('12/31/2003','mm/dd/yyyy')- to_date('1/1/2003','mm/dd/yyyy') +1;