ThatJeffSmith

Oracle SQL Developer Quick Hit: Paren Matching

Today’s Question:

Does anyone know of an editor (or program) that will match beginning and
ending parentheses in sql and highlight an ending paren that is missing?

It just so happens that I do know of such an amazing editor or program :)

I’ll let the pictures do the talking for me this afternoon:

Matched Parens

The good: Blue

The good: Matched paren pairs in blue

Missing Parens

The bad: Orphaned Paren highlighted in red

The bad: Orphaned Paren highlighted in red

Next question?