There are many tutorials on the web, but here's how to modify the Oracle parameters in the registry if the Oracle client is not installed?
Of course, some do not need to change the registry, only need to configure the environment variables can be, but sometimes found that after the change is not so, in this case can only modify the registry.
You go to the bottom of the registry to see Hkey_local_machine->software->wow6432node see if there is an Oracle option, if not yet we add one; The code is set up as follows two suffix named American_ 10g.reg and Chinese_10g.reg (the name is not important, the key is the suffix name) of the registry;
You can save the content to Notepad first, then change the suffix to Reg, and then drag and drop it into the registry, which automatically matches the location according to the path.
123456 |
windows Registry Editor Version 5.00 [hkey_local_machine\software\oracle\key_oradb10g_home1] = "American_america. Us7ascii " windows Registry Editor Version 5.00 [hkey_local_machine\software\oracle\key_oradb10g_home1] "Nls_lang" = "Simplified Chinese _china. ZHS16GBK " |
My plsql is installed here D:\Program files\plsql Developer "After you download the registry in the Plsql directory after running, press Win+r (Win is the button with the Microsoft icon), enter: Regedit to open the registry. To modify the "hkey_local_machine->software->oracle->key_oraclient11g_home1" in the local registry-----Right-click nls_lang--click-Modify-- The value data is changed to: American_america. ZHS16GBK, remember to re-enter the previous database data. (see if it is already GBK, you do not need to modify it)
Plsql Query Results Chinese garbled