Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert additional records based of another

User_JP93MMar 4 2021

Hi everyone,
I have a record like this:
some_id | … | starting_date | frequency
34 | … | 2021/01/04 | 14
35 | … | 2021/01/18 | 14
Where "starting_date" is a date and "freuqncy" is a number that explains after how many days another record (here 35) is to be inserted.
Is there a way to do this automatically in Oracle SQL?
Thanks in advance
Markus

Comments

Post Details

Added on Mar 4 2021
5 comments
1,305 views