<p>How can I write an insert statement which includes the &amp; character?  For example, if I wanted to insert "J&amp;J Construction" into a column in the database.</p>

<p>I'm not sure if it makes a difference, but I'm using Oracle 9i.</p>

If you are using sql plus then I think that you need to issue the command
```
```
SET SCAN OFF
```
```