tag:blogger.com,1999:blog-1271763227002553835.post627998139934355834..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Generate Rows based on a Column ValueAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1271763227002553835.post-49989765109470002232017-03-20T12:17:31.690+01:002017-03-20T12:17:31.690+01:00Like it!
See you in Dublin :)Like it!<br />See you in Dublin :)Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-91082560584669842982017-03-20T12:13:36.015+01:002017-03-20T12:13:36.015+01:00Hi Alex.
Here is an alternative that calculates th...Hi Alex.<br />Here is an alternative that calculates the number of minutes for each repetition inside the lateral inline view:<br /><br />select a.activity<br /> ,to_char (a.activity_date, 'dd-mm-yyyy hh24:mi') start_time<br /> ,to_char (a.activity_date + numtodsinterval(r.minutes,'minute')<br /> ,'dd-mm-yyyy hh24:mi') as calculated_time<br /> from activities a<br /> ,lateral (select (level-1)*5 minutes from dual connect by level <= a.no_of_reps) r<br /><br />Thanks, and see you in a few days :-)<br />Oren.Oren Nakdimonhttps://www.blogger.com/profile/05183397716813045976noreply@blogger.com