concatenate nvarchar with number
Can somebody help us with the folowing :
We have a table with some nvarchar2 fields.
With a select we want to get a result with a concatenated nvarchar2-Field and a number-field
like this : select feld1 || N' ' || feld2 || numeric_Field
But we get a ora-12704 character set mismatch error. Without the number it works fine
even .... N'numeric_Field does not work!
how can we add numerical with nvarchars ?
thanks in advance