The Oracle (tm) Users' Co-Operative FAQ

How do I get SQL*Plus to store an ampersnad (&) & in the database ?

Back to index of questions

The & is a special character to indicate a substitution variable. To override this, and thus allow & to be treated like any other character, all you need is:

SQL> set define off
SQL> insert into table values ('value&with&ampersand');

  1 row created.

Further reading: N/A

Back to top

Back to index of questions