Starting the SQL Shell

You can run SQL queries and execute DDL statements directly from the SQL shell. This is described in Introduction to the SQL for Oracle NoSQL Database Shell. To run the queries shown in this document, start the SQL shell as follows:

java -jar KVHOME/lib/sql.jar
-helper-hosts node01:5000 -store kvstore
sql-> 

Note:

This document shows examples displayed in COLUMN mode, although the default output type is JSON. Use the mode command to toggle between COLUMN and JSON (or JSON pretty) output.