Oracle ODBC connectivity - June 17, 2010 at 12:30 PM by Babu
Kunwar
ODBC stands for Open Database Connectivity is an interface written in C program.
Oracle ODBC Driver provides a standard interface that allows one application to
access many different data sources................
Read Answer
ODBC is databasing independent where as NET8 is database
dependent...............
Read Answer
First we need a client software such as SQL*Net or Net8 on the client machine.
There is however 3rd party solutions that provide a "native Oracle OCI driver"
that includes Oracle networking within the driver................
Read Answer
In database terms, a data source is a specific set of data, and we can have one
or more data sources active in our application at one time.................
Read Answer
As I have configured this on the UNIX machine I don’t have any idea about
Windows. Here are the details of tracing the ODBC call on UNIX
platform.................
Read Answer
We use SQLPASSTHROUGH options when we need applications to access data both in
the front-end and back-end data servers with a single
connection......................
Read Answer
Microsoft Access is part of the Office 2000 suite and has a strong ability to
“link” to tables in other databases including Oracle. The connection is done
through.....................
Read Answer
There are many techniques for doing this. I will present one non-programming
technique. Just one thing we need is SQL Developer tool. SQL Developer is a
tool which is used for querying Oracle database.................
Read Answer
Oracle server implicitly starts a new transaction with the following two
conditions: The first executable statement of a new user session automatically
starts a new transaction.............
READ COMMITTED: If row locks are obtained by a certain transaction, then any
other transaction that contains DML needs to wait until the row locks have been
released by that particular transaction.............
A recent copy of a table or a subset of rows or cols of a table is called as
snapshot in oracle. A snapshot is more useful in distributed computing
environment. We can create...........
|
