You can also use PL/SQL without installing an Oracle client

How can i use PL/SQL without installing Oracle? Oracle is hundreds of M, and in today's machine configuration, of course, space is not a problem, but sometimes some of the services that are launched have a small performance impact. Use Instantclient bar, no installation, free, simple configuration, do not start the service.

Go directly to oralce official website to download the latest version of Instantclient, there is a windowslinuix version, download the choice to pay attention to the version.

2. After the download is a compressed package, directly extracted to the disk directory. such as c:instantclient1025

4. Create a directory within a folder,/network/admin. such as c:instantclient1025networkadmin

6. Copy an Tnsnames.ora,sqlnet.ora from another machine and put it in the directory C:instantclient1025networkadmin

   such as: C:instantclient1025networkadmin Nsnames.ora

   C:instantclient1025networkadminsqlnet.ora

8. "database server-side character set" Nls_lang=simplified Chinese_china. ZHS16GBK

   "instantclient directory" Tns_admin=c: Instantclient1025networkadmin

10. modify the PL/SQL parameter. Open PL/SQL, Tools---preferences---oralce:connect "tool---preference---oracle:connect" modifies the parameter values of the Oralce home and OCI Library.

          "OCI directory" oci library  = C : Instantclient1025oci.dll

        If there is no oci.dll, you can copy it to another machine, this is a dynamic library file.  

       

                    

12. When you turn off PL/SQL and restart, you can choose to use the database connection defined in Tnsname.ora.

    Database connection configuration, you can modify the Tnsname.ora file with a text editor.

You can also use PL/SQL without installing an Oracle client