SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between U String literal and N String Literal

Rajan SwMar 5 2020 — edited Mar 10 2020

Hi I am Analysing some procedures and as part of the procedures there are some stmts like below and when compiing I am getting errors.

Need to know what is the use of using u here and how to fix this.

is there any risk if remove u part from the stmts ??

I am using Oracle 12c R2

select distinct case when a.action is NULL then u'Next' else a.action end as action,

a.actionscript as actionlink

Error :

Error(229,81): PL/SQL: ORA-12704: character set mismatch
Error(245,9): PL/SQL: SQL Statement ignored

Added on Mar 5 2020

3 comments

942 views