Enterintg the special Characters into table

[admala]

Originally posted by Krutsinger
You can either use the escape character (\') or use '' (two single quotes) to insert a string with a single quote.

Here I am writing the query in the following way

update rem_reports set RPT_COLUMNS='Project Name, Division, District, Program, Purpose, Tract Number,Owner\'s Name, Acreage, Acquired Cost, Estate Code, Remarks,
Method of Accomplishment'
where rpt_name='1019'

RPT_COLUMN is a VARCHAR2(2000) in the table.

Thank You,
Praveen.