dear members of the community,
i have three columns - one character and two numeric - that i would like to concatenate into a long string as in the picture and the attachment.
for some reason, when the character is written in Arabic the concatenate results is in the wrong order.
"('" || :word || "', " || Char( :abc ) || ", " || Char( :def ) || ")"
this is not good for my application since i export the column as a matrix in the next stage to use in SQL and the whole process fails.
many thanks for your input.
