var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DECODE and LOB
I'm Trying to create an UPDATE statement using the DECODE function in Oracle8 on a LOB field.
Yes, I know it will throw an error about inconsistent datatype.
my question is, is there any workaround for this thing ?
(I don't want to write my own PL/SQL function that will try to do what i want, if there is a simplier way ... ).
my statement is :
UPDATE test_table SET lob_type = DECODE(1, 1, 'TEST', lob_type);