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.