By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

use of escape character in sql

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Priti Goyal" <pr******@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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.