-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|