17,140
社区成员




insert into journal_file_info(FILE_ID, FILE_NAME, FILES_TYPE, JOURNAL_DATE, FILE_STATUS)
select c.ID+rownum,'trade-'||to_char(a.vdat,'yyyymmdd'),'0',a.vdat,'0'
from (select to_date(to_char(sysdate- rownum,'yyyy/mm/dd'),'yyyy/mm/dd') vdat
from dual
connect by rownum <=30) a,
journal_file_info b,
(select nvl(max(to_number(FILE_ID)), 0) ID from journal_file_info) c
where a.vdat=b.JOURNAL_DATE(+) and b.JOURNAL_DATE is null;
insert into FILE_INFO(FILE_ID, FILE_NAME, FILES_TYPE, JOURNAL_DATE, FILE_STATUS)
select c.ID+rownum,'trade-'||to_char(a.vdat,'yyyymmdd'),'0',a.vdat,'0'
from (select to_date(to_char(sysdate+ rownum-1,'yyyy/mm/dd'),'yyyy/mm/dd') vdat
from dual
connect by rownum <=30) a,
FILE_INFO b,
(select nvl(max(to_number(FILE_ID)), 0) ID from FILE_INFO) c
where a.vdat=b.JOURNAL_DATE(+) and b.JOURNAL_DATE is null
insert into FILE_INFO(FILE_ID, FILE_NAME, FILES_TYPE, JOURNAL_DATE, FILE_STATUS)
select c.ID+rownum,'trade-'||to_char(a.vdat,'yyyymmdd'),'0',a.vdat,'0'
from (select to_date(to_char(sysdate+ rownum-1,'yyyy/mm/dd'),'yyyy/mm/dd') vdat
from dual
connect by rownum <=30) a,
FILE_INFO b,
(select nvl(max(FILE_ID), 0) ID from FILE_INFO) c
where a.vdat=b.JOURNAL_DATE(+) and b.JOURNAL_DATE is null