Skip to Main Content

Maintaining SQL Code: Lexicals Are Used, How to decipher?

Bob ParisAug 20 2019 — edited Aug 21 2019

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.

Post Details
Added on Aug 20 2019