How to set Oracle SQL*PLUS character set

PROBLEM:
When opening your SQL*PLUS you see unrecognized characters, something like this:

SOLUTION:
To change SQL*PLUS language to english:
1. Close SQL*PLUS
2. Search "NLS_LANG" in the registry
3. Change the value to AMERICAN_AMERICA.WE8MSWIN1252
4. Open again SQL*PLUS to see changes

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

Show connected user in Oracle SQL*PLUS command prompt

PROBLEM:
You want to see your connected user name in SQL*PLUS command prompt

SOLUTION:
You need to edit your glogin.sql file located in the following path:

oracle_home\product\11.2.0\dbhome_1\sqlplus\admin\glogin.sql

Add to the original file contents the following lines:

set serveroutput on
prompt hello!
set lines 120 pages 120
set sqlprompt '_user> '

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!