update statement for a table's column (Long)

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
baberamin
Posts: 4
Joined: Tue May 29, 2007 4:30 am
Location: Pakistan

update statement for a table's column (Long)

Post by baberamin »

"inival" column is Long type. I wan to set this value
{'XYZ','\\\\pqr\\uvw\\'}

I was trying this SQL

update table_abc
set inival = '{'XYZ','\\\\pqr\\uvw\\'}'
where inisection = 'V.L'


and the error was



set inival = '{'XYZ','\\\\pqr\\uvw\\'}'
*
ERROR at line 2:
ORA-00933: SQL command not properly ended


and if used set inival = "{ }"

then error is

set inival = "{'XYZ','\\\\pqr\\uvw\\'}"
*
ERROR at line 2:
ORA-00972: identifier is too long


Can anyone help?
gmohan
Posts: 13
Joined: Sat Jul 07, 2007 9:18 am
Location: India

Post by gmohan »

hi,

try this query

update table_abc
set inival = '{"XYZ","\\\\pqr\\uvw\\"}'
where inisection = 'V.L'

Thanks
Mohan
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest