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!

Need SQL Query to get time intervals

ursveeraAug 16 2022 — edited Aug 16 2022

Hi,
I need help in query to get intervals of event and timestamp combination (even if there is a gap of 1 second, we need an additional interval). below are the sample data and expected results.
Input
--------------------------------------
image.png
And the expected Output is
image.png
Thanks,
Veera

Comments
Post Details
Added on Aug 16 2022
7 comments
255 views