Monday, November 14, 2016

Adding Reserved command in SQLcl

I saw Stephen's example of checking reserved words in the database from Vertan's day and figured I'd do the same in SQLcl.

Checked if something is reserved seems like a nice add on for the tooling.  This example adds a SQL>reserved command that checks all words passed to see if they are in the single source of truth which is v$reserved_words

The outcome is something like this.

The code is in the normal location on github.  It follows the same CommandRegistry/CommandListener that was used in lots of the previous examples.