Pages
Home
Legal
About me
How To
Source Code
Publications
Sheet music
Finance
Link dump
Comics
06/11/2012
[SQL] Oracle insert & (AND) character
To insert the
&
character in a string field in Oracle, you may need to split the string in two parts then concatenate them together putting the special character in the middle using the
CHR
function:
'string_part1'||chr(38)||'string_part2'
No comments:
Post a Comment
With great power comes great responsibility
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
With great power comes great responsibility