Skip to content
Advertisement

Populate data to tables as per daterange

I have a table in Oracle:

I want to combine the START_DT and END_DT columns to a single column named ‘DATES’ as per the corresponding date range.

Eg: take LEAVE_DTL_ID = 186 it has START_DT = '02-MAY-19' and END_DT = '06-MAY-19'.

I want to populate the data as

Is there any way to accomplish this ?

Advertisement

Answer

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement