Remotely connect an Oracle server to troubleshoot Oracle query garbled language

Dos method:

Based on

Files under the directory

Connecting using the Plsql developer client software

Need to configure:

is to configure the DOS client in.

Then, copy the server-side files to your machine.

and set the TNS_ADMIN environment variable to this directory (do not have the Chinese character number and so on the directory)

So the landing is successful.

Solve Chinese garbled problem

Modify the Scott user password

Alter user Scott identified by Tiger

--fuzzy query to capitalize
SELECT * from emp where ename like Upper (' s% ')
--Search for employees who have been in employment in 1981
--Method One
SELECT * FROM EMP where to_char
(HireDate, ' yyyy-mm-dd ') between ' 1981-01-01 ' and ' 1981-12-31 '
--Method Two
SELECT * FROM EMP where hiredate
Between To_date (' 1981-01-01 ', ' yyyy-mm-dd ') and to_date (' 1981-12-31 ', ' yyyy-mm-dd ')

--Sort empty in front empty behind
SELECT * FROM emp ORDER by Comm Nulls First
SELECT * FROM emp ORDER BY comm Desc nulls
-Interception of numbers or dates
Select Trunc (2.66) from dual
Select Trunc (2.66,1) from dual
--Replacement
Select replace (' abcdef ', ' abc ', ' Okokok ') from dual

Remotely connect an Oracle server to troubleshoot Oracle query garbled language