Networking of Databases - Multiple Context Interface -

One important use of networks is to provide access to a database that is on a server. Such use of databases has made company wide databases quite effective. Many applications can be used to enter data into, view data from, or print data from a common database. The process involves a set of software that expands the capability of buffering, using object oriented processing to produce very capable database connections and record-sets. These connections provide record-sets from the database based on any standard SQL select query of the database. The connection can also carry out commands on the database like inserts and updates.

See also: The Animated Computer

In this code a connection is opened using a connection string that defines the provider, the data source (the specific Oracle schema), the user id, and the password. An SQL statement is used to define a command that is used to open a data reader with a specific record from the table named in the SQL query. The record produced is shown on three lines on the console. Then the data reader is closed; and the connection is closed.

Dr. Jerome Heath