"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?
update statement for a table's column (Long)
Who is online
Users browsing this forum: No registered users and 1 guest