Insert special characters text into table

[barnard90]

Hi
I have an table with Employee description
It is varchar2(2000)
I need to enter special characters like ",", "'", "&", ":" ,
"$" etc into that column

for example the Employee description can be like

" 1) This employee John Turner, joined at London's Procter & Gamble office for $5000 salary at 9:30 AM ".

How can I enter this data
I am having problems with entering the special character

Could some one please suggest me a method , how I can enter this value

thanks

 

[LKBrwnDBA]

Try:

SET DEFINE OFF



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[taupirho]

You can also use the CHR construct

e.g

insert into employee(emp_desc)
values(chr(39) || 'This is single quoted text'|| chr(39) || ' followed by a dollar sign ' || chr(36))

How do you get the number to put in the brackets after CHR, siimple - use the ASCII function

eg select ascii('$') from dual -> returns 36