OraFAQ Forum: Server Administration » Masking special characters in SQLPLUS

Home » RDBMS Server » Server Administration » Masking special characters in SQLPLUS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Masking special characters in SQLPLUS [message #373824]

Mon, 14 May 2001 14:18

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

Report message to a moderator

Re: Masking special characters in SQLPLUS [message #373849 is a reply to message #373824]

Tue, 15 May 2001 16:29

Sundar Venkatasubramaniam
Messages: 26
Registered: May 2001

Junior Member

To mask %

assume that your input is abc%def%gh

then you can try like this

update my_table set my_field= chr(37)||'abc'||chr(37)||'def'||chr(37)||'gh'
where my_prim_key ='X';

If you want other than this please explain in more detail.

Report message to a moderator

Previous Topic:	OCP developer. test ...please reply........
Next Topic:	Order By

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:04:44 CST 2024