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!

Return concatenated value of same column where row contains last two modified column values

Mr.PeabodyApr 15 2021 — edited Apr 15 2021

I have last_modified (datetime) column and based on that, I want to have rows where row consist the last two modified concatenated values in the column.
It should contain all the last modified values combination.
Existing Values

Value     Last_modified_date
0           25-01-18
1           26-01-18
5           16-02-18
2           02-03-18
4           21-05-19
7           15-09-19

**Required Format:**

old_value (highphen) current_value
         0 - 1
         1 - 5
         5 - 2
         2 - 4
         4 - 7

This post has been answered by cormaco on Apr 15 2021

Jump to Answer

Added on Apr 15 2021

#oracle, #sql, #sqldeveloper

2 comments

73 views