Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting Values containing single quotes

405330Oct 1 2003 — edited Oct 2 2003
I want to insert a single quotes ( ' ) in varchar2 field but it show errors.How I can add a single quote while Iam inserting values through SQL. For example : the data is "Maria's" , then how I can add this name to a varchar2 field.

Error Details :- quoted string not properly terminated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2003
Added on Oct 1 2003
2 comments
1,830 views