Inserting & in oracle  

Posted by Kishore in

If there are any & symbol in your sql insert query value, replace it with &'||'. (In case if the query fails to run)

The & will be considered as beginning of variable name in Oracle SQL.

Note: This is only if the & symbol is inside quotes.

Eg:

Insert into temp values(2.’me&u’); è Insert into temp values(2.’me&’||’u’);

This entry was posted on Apr 13, 2009 at Monday, April 13, 2009 and is filed under . You can follow any responses to this entry through the comments feed .

0 comments

Post a Comment