Sql client, although the most convenient is universal and extremely light weight of Sql Workbench, Otherwise, Oracle is using up most succulent of should or pl / sql Developer. Development of the machine is too lazy to install stout of Oracle, even if the client is extremely heavy.
Fortunately found a free installation of Windows, the client can use Oracle pl / sql developer handy way to share:
1, from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html the Download Instant Client, note the next two basic package can not recommend basiclite (I downloaded is about 45M of that) (download time to mail registration)
2, the disk to create the directory, unzip the past, eventually extracting file will be in the same directory. For example extract to c: \ oracleclient
3, create the directory c: \ oracleclient \ network \ admin
4, create file tnsnames.ora as follows (you can also copy over your original cover on the line)
(ADDRESS = (PROTOCOL = TCP) (HOST = yourhostIp) (PORT = 1521))
(SERVICE_NAME = yourSID)
) Copyright Sqlclub
5, set the pl / sql Developer's perference:
oracle_home: "c: \ oracleclient \"
OCI Library: "c: \ oracleclient \ oci.dll"
6, restart the pl / sql developer, user name password, and set oracledata tnsnames.ora
7. To solve the problem of Chinese garbage, set the environment variable nls_lang = SIMPLIFIED CHINESE_CHINA.ZHS16GBK or you can directly run the following batch.
Reprinted from: http://www.javagov.cn/article/Document/211.html