OraFAQ Forum: Server Administration » insert substitution character '&'

Home » RDBMS Server » Server Administration » insert substitution character '&'

Mon, 30 September 2002 02:05

Hiren
Messages: 29
Registered: September 2002

Junior Member

i want to insert values containing '&' character in a varchar2 field.
for eg 'L&T','AT&tT'

Mon, 30 September 2002 04:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use an ESCAPE CHARACTER.

SQL> set escape '/'
SQL> select 'l/&T' from dual;

'L&
---
l&T

Tue, 01 October 2002 16:32

andrew again
Messages: 2577
Registered: March 2000

Senior Member

or
SQL> set scan off

or
SQL> set define '~'

If you change the define character you just move the problem to that character though.

Previous Topic:	daily export hanging
Next Topic:	Oracle8i install

Goto Forum:

]

Current Time: Fri May 01 21:11:41 CDT 2026