The Oracle (tm) Users' Co-Operative FAQ

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


Author's name: Connor McDonald

Author's Email: connor_mcdonald@yahoo.com

Date written: August 13, 2001

Oracle version(s): 7.3+

How do I get SQL*Plus to store an ampersand (&) 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