Looking for a SQL Developer guru that understands how to use the tool better than I do.
I am maintaining existing SQL code and lexicals are used throughout. No comments or documentation exist. Both the code and the process it supports are new to me
I am working on understanding the previous developer's thought process and design by disassembling some of the complex queries into simpler queries with same joins.
Looking for any "easy" way in SQL Developer to do the substitution of the lexicals to validate the queries separately. Debug not providing what I am expecting. My expectation my be incorrect.
Please assist.