Monday 22 November 2021

Oracle : Display Arabic Character in the Linux Terminal sqlplus Prompt

 Set the NLS_LANG parameter and connect as sqlplus and execute the command.

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

sqlplus / as sysdba

<your sql select statement>

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...