Inserting a text value with special characters
by Frank Kim on May.29, 2007, under Oracle
To insert a text value with an ampersand, e.g. AT&T, one can do something like this.
insert into foo values(‘AT’||Chr(38)||’T')
To learn more see How does one disable interactive prompting in SQL*Plus?
To insert a text value with a single quote, e.g. Don’t do it, one can do something like this.
insert into foo values(‘Don”t do it’)
To learn more see How does one escape special characters when building SQL queries?
Related posts:
-
Innovate!
betweenGo is a web solutions provider, specializing in Ruby on Rails and ATG enabled solutions.
If you're interested in becoming a betweenGo client, please contact us.
Please feel free to join the discussion by leaving comments and stay updated by subscribing to the RSS feed.
You can also follow us on Twitter.
You can also subscribe by email by filling the field below:
