use of escape character in sql

[Priti Goyal]

Hi,
My data contains a single quote character and i want to replace this
single quote with a double quote in a PL\SQL stored procedure.
the statement i m using is:
update system.daily_fe ed
set Inv_Name = replace(‘get_da ilyfeed.Inv_Nam e','/'','`') where
TRXN_ID=get_dai lyfeed.TRXN_ID

escape /;
here get_dailyfeed is a cursor and inv_name is column name.
but always it is throwing an error: (PLS-00103: Encountered the symbol
"") .

My second question is:
how do i insert single quote within a table, suppose my name field is
like Jayan'ta. what should be my corresponding sql statement
Thanks

[Guido Konsolke]

Re: use of escape character in sql

"Priti Goyal" <priti_04@hotma il.comwrote...

Hi,
My data contains a single quote character and i want to replace this
single quote with a double quote in a PL\SQL stored procedure.
the statement i m using is:
update system.daily_fe ed
set Inv_Name = replace('get_da ilyfeed.Inv_Nam e','/'','`') where
TRXN_ID=get_dai lyfeed.TRXN_ID
>
escape /;
here get_dailyfeed is a cursor and inv_name is column name.
but always it is throwing an error: (PLS-00103: Encountered the

symbol

"") .
>
My second question is:
how do i insert single quote within a table, suppose my name field

is

like Jayan'ta. what should be my corresponding sql statement
Thanks

Hi Priti,

please search the archives. Your problem has been solved many times.
One thing I'd like to point out: NEVERneverNEVER store your data
in a schema SYSTEM or SYS. You are calling for trouble.

hth,
Guido