Nov 24, 2010

insert ampersand in oracle table

Hi,
This solution will work everywhere, no matter if you are using TOAD,sql plus, pl sql developer.
let's say we want to insert this "hello&world" inside a table that includes key's and values.
And our key, let's say is "title"
For example :
insert into table_name (keys,values) values ('title','hello'||chr(38)||'world');
That's the whole story.
Hoped i helped,
Dor

2 comments: