Hi,
I wanted to insert the row which contains the value like
Owner's.

I am updating the column like the following way
Update temp set rpt_columns='Project Name, Division,Owner's,District' where rpt_name='1099';

I am getting the following error in the above statement

ORA-01756: quoted string not properly terminated.

Because I am inserting the value Owner's into the table.

Please help me out how do we enter the special characters like above in the table. I used escape on and tried still its not worked.

Thanks in advance
Admala.