Try selecting some information form the table
sql> SELECT * FROM testTable Error: Table 'testTable' not found. sql>
Unsurprisingly, this gives an error message since we haven't yet created a table. All the supported commands, including creating a table will be demonstrated in the section SQL Reference.
If you are new to SQL you should read the SQL Reference and test the examples using the interactive prompt.
To exit the Interactive Prompt type
exit and press Enter:
sql> exit C:\Documents and Settings\James\Desktop\scripts>
You will be returned to the usual command prompt.
Some test SQL commands can be sound in the file web/external/PDBC/database/external/SnakeSQL/test/test.sql. You can copy and paste the commands into the prompt and you should see output similar to that specified in the test.sql file.