Install and use ORACLE Instant Client and sqlplus

First go to the official website to download the appropriate version, I am win7 64-bit system, so download the latest instantclient-basic-windows.x64-11.2.0.2.0 and instantclient-sqlplus-windows.x64-11.2.0.2.0, decompress to the same file, such as instantclient_11_2.

Create a tnsnames. ora file under the folder and enter the database information. The following is an example:

Xe. world = (description = (address_list = (address = (community = TCP. world) (Protocol = TCP) (host = 192.168.1.100) (Port = 1521) (CONNECT_DATA = (SID = Xe )))

Open the windows command line below, enter the folder just now, enter the sqlplus username@XE.WORLD (from the above example, replace it with your real name.

Refer:

Http://www.ioncannon.net/system-administration/114/using-oracle-instant-client-and-sqlplus/