Skip to Main Content

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!

escape character in insert-statement

724773Jun 21 2011 — edited Jun 21 2011
Hi

I have to execute an Insert-Statements for Example

insert into tab(.......)
Values ('1','XX'XX'); ---> the character ' inside this string cause an error
insert into tab(.......)
Values ('1','XXXXX');

how to suppress the ' character in the String.

br.

MDK.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2011
Added on Jun 21 2011
5 comments
1,729 views