I've been reading upon the definitions of oracle instant client and oci but being new to oracle database having a bit of difficult time to understand what they are/for. I would appreciate someone can clarify the difference of two. Thank you!
Oracle Instant Client vs OCI – What is the Difference?
oracle
Best Answer
OCI is short for "Oracle Call Interface". It's essentially the API that defines how program (a "client") can communicate with the database server.
The instant client provides an implementation of the OCI that can be used by other programs, so that they don't have to implement the communication layer. It is e.g. used by SQL*Plus or other client applications.