hai friends,
i have a simple problem .. i need to insert :  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(': ');
Enter value for nbsp: john
old 1: insert into tst_tab values(': ')
new 1: insert into tst_tab values(':john')
1 row created.
actually i need to insert ": " as a strings but i cant...
note : *:* and *&*
so please help me to solve this problem...
regards,
john