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

2011-01-01

1028

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 ?

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.

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

The Oracle (tm) Users' Co-Operative FAQ

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

评论