1.你可以这样 select max( 唯一ID) maxid from table1 insert into table1 nologging (select rownum+maxid , t.* from table2)2.可以用select substr('20050101',0,4)||'-'||substr('20050101',5,2)||'-'||substr('20050101',7,2) from dual; 或者 select to_char(to_date('20050101','yyyymmdd'),'yyyy-mm-dd') from dual
2.select to_date('20050101', 'yyyy-mm-dd') from dual
insert into table1 nologging (select rownum+maxid , t.* from table2)2.可以用select substr('20050101',0,4)||'-'||substr('20050101',5,2)||'-'||substr('20050101',7,2) from dual;
或者
select to_char(to_date('20050101','yyyymmdd'),'yyyy-mm-dd') from dual