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!

Input an apostrophe

526410Aug 15 2006 — edited Aug 16 2006

Hi all,

I know in PL/SQL if i want to input a text that contains an apostrophe it must be input with two apostrophe's, i.e. O'Connor must be O''Connor but is there anyway a PL/SQL procedure can perform a REPLACE to enable this. Reason being i want to avoid doing the replacing of something like O'Connor with O''Connor outside the PL/SQL package.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2006

Added on Aug 15 2006

13 comments

550 views