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!

how to handle ' single quote in my stored procedure

curious_mindNov 27 2019 — edited Dec 2 2019

Hi All,

I have a table column where the value is stored as mentioned below

RRR'R

now while select on my table it is not working due to the single quote, could you please help me on this.

select * from SORCA01.USR_LIST_MBR where LIST_ID='9fca5e7525aa0000016ea854d19a0045'

and usr_list_mbr_val_txt = 'GXZ'D';

and the error i am getting is :

ORA-00933: SQL command not properly ended

00933. 00000 - "SQL command not properly ended"

Please suggest how to handle this in my query.

Added on Nov 27 2019

12 comments

4,260 views