Home » RDBMS Server » Server Administration » Masking special characters in SQLPLUS
Masking special characters in SQLPLUS [message #373820] Mon, 14 May 2001 13:46
S Bala
Messages: 9
Registered: April 2001
Junior Member
Hi,
How will i mask special characters when i input them as
data to the table.eg
SQL>update my_table set my_field= 'here's the field' where my_prim_key ='X';

ERROR i get :
-----------------
ERROR at line 1:
ORA-00933: SQL command not properly ended
------------------
Here i want to insert a single quote(') as a text string into my oracle field .
i also tried a backslash(\) before the qoute ,but it doesn't help.
Please suggest me a solution.
Regards,
S Bala
Previous Topic: Re: sql help - I have a prob too
Next Topic: Masking special characters in SQLPLUS
Goto Forum:
  


Current Time: Tue Jul 02 17:30:36 CDT 2024