Tuesday, March 15, 2011

Oracle Insert Statement Containing & (Ampersand)

So I needed to insert some data into an Oracle DB and found it was having issues with the ampersand (&). So I did some digging and found that before my insert statement I just execute the statement:


set define off

This proved very handy :-)

Source: http://forums.oracle.com/forums/thread.jspa?threadID=466604

No comments:

Followers