Skip to Main Content

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 insert " :&nbsp " to a table

jp609096Feb 6 2010 — edited Feb 10 2010
hai friends,

i have a simple problem .. i need to insert :&nbsp this string into the table ...but it is a bind variable ..hence it is pop up for the input values...but i need to insert the string itself...how can i sove this problem...

for escaping & i used the *\* but i can't trap
like,
 SQL> insert into tst_tab values(':&nbsp');
 Enter value for nbsp: john
 old   1: insert into tst_tab values(':&nbsp')
 new   1: insert into tst_tab values(':john')
 
 1 row created.
                         actually i need to insert ":&nbsp" as a strings but i  cant... 
                         note : *:* and  *&*


 
so please help me to solve this problem...

regards,
john
This post has been answered by 730428 on Feb 6 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2010
Added on Feb 6 2010
14 comments
15,548 views