Hello,

is there any possibility to get null-values as text 'null' from dynamic select 
expression like

SELECT ROW(t.*) FROM table t

Normally you get

(t1,t2,t3,,t5,,,)

How can you get

(t1,t2,t3,null,t5,null,null,null)

I would like to use the result with dynamic update expression and update 
doesn't like of empty values, so

UPDATE SET (t1,t2,t3,t4,t5,t6,t7,t8) = (t1,t2,t3,,t5,,,)

generates error.


Best regards,
Teemu Juntunen, e-ngine

Reply via email to