I need an update statement
Posted on 2012-04-05
I've the following select statement in a column:
to_char(column1), to_number( Null ), credavlby, tenor, tenordays,
I need this select statement to be as the following by using an update statement:
to_number( Null ), credavlby, tenor, tenordays,
I need to replace "to_char" with "replace(to_char"
And keep "column1" and "column2" as it is,
The value for coulmn1 and column2 is Changeable not a fixed value
Then after "(column1)" add ",''__'',chr(10))"
Thanks in advance,