Oracle Installation-free PL/SQL connection

Use PL/SQL to connect to Oracle without installing the Oracle client
 
1. Download a software named Instant Client Package from the Oracle website. This software does not need to be installed and can be used as long as it is decompressed. : Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html.
 
2. download the software package, decompress it to any directory (for example, D: \ Program Files \ oracle_client), create a NETWORK folder under this directory, create an ADMIN folder under it, and then create tnsnames. the ora file contains the following content:
RFITMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.88.248.95) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = rfitms)
)
)
Set it here based on your actual situation.

3. Enable PL/SQL and configure tools> preferences> connection.
Oracle Home = D: \ Program Files \ oracle_client \ instantclient10_1
OCI library = D: \ Program Files \ oracle_client \ instantclient10_1 \ oci. dll
This is also set based on your actual situation.

4. Add an environment variable named TNS_ADMIN. The value is the path of the tnsnames. ora file (for example, D: \ Program
Files \ oracle_client \ NETWORK \ ADMIN) to locate tnsnames. ora. When setting the ORACLE language, you need to add the environment variable: NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK.
 
5. Restart PLsql