Re: use of escape character in sql

"Priti Goyal" <priti_04_at_hotmail.com> wrote...
> 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_feed
> set Inv_Name = replace('get_dailyfeed.Inv_Name','/'','`') where
> TRXN_ID=get_dailyfeed.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 Received on Fri Jan 16 2004 - 12:26:53 CET