SQL .mode insert command

Check or uncheck View > Show/Hide > SQL to toggle the visibility of the SQL Control Bar.

.mode insert command

The ".mode" command is used to switch between the output formats shown above.

This is an example of the .mode insert command.

Use an overlay named Mastermap.gz to select Items with a feature code of 10172 to add SQL insert statements for TABLE, enter the following at the SQL> prompt:

.mode insert

select * from "Mastermap.gz" where featurecode=10172;

In this example the following will be shown:

---