Shulou(Shulou.com)06/02 Report--

Download instantclient-basic-nt-18.3.0.0.0dbru.zip,instantclient-basiclite-nt-18.3.0.0.0dbru.zip,instantclient-sqlplus-nt-18.3.0.0.0dbru.zip from 1.oracle official website

Windows 32-bit instantclient-basic download

Extract the iinstantclient-basic-nt-18.3.0.0.0dbru.zip to a path, such as under disk D, or under a folder (D:ORACLE\ instantclient_18_3). Extract the files in nstantclient-sqlplus-nt-18.3.0.0.0dbru.zip to D:ORACLE\ instantclient_18_3.

At this point cd D:ORACLE\ instantclient_18_3

Sqlplus user/password@192.168.10.101/dbname

Should be able to connect to the database on the remote server

5. Add D:ORACLE\ instantclient_18_3 to the computer environment variable

Computer-properties-advanced system settings-environment variables

Variable value

ORACLE_HOME D:ORACLE\ instantclient_18_3

Path: original environment variable; D:ORACLE\ instantclient_18_3

Ok can use sqlplus to connect to the server database in the cmd environment.

6. In insert into or update table data, oracle database design requires commit/commit work or normal SQL > quit/exit data to be submitted and saved. If it is through ssh--sqlplus, if you close the window directly after insert/update, it will not be submitted and saved to the library.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.