Skip to Main Content

Oracle Database Discussions

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 logics for below query

Mahendran PSep 2 2023 — edited Sep 2 2023

Hi ,

Need logics for below output.

Input:

Output:

Note:

Here if change reason , we need to update change date to pervious reason ID.

Added on Sep 2 2023

#database-and-application-migrations, #general-database-discussions, #oracle, #pl-sql, #plsql, #sql, #sql-developer, #sql-pl-sql, #sqlplus

10 comments

307 views