Is there an ODBC driver available for your Oracle database? If so, the ODBC functions may be the way to go.
By using ODBC
yes because odbc stands for open data base connectivity and it support a lot of data bases. like mysql, ms-access, oracle, sql server etc.
Have your form's input insert into a database (SQL, Oracle, etc) then access that database through Access's ODBC connection.
Need to find out the Oracle Connecting driver's that work for C or C++. e.g. Java uses JDBC-ODBC driver to connect to Oracle data base ..... (4 different types of JDBC drivers are available) There should be such drivers for C or C++ language as well ..... Google on C++ Oracle driver .... You can use the Oracle precompiler (Pro*C) or the Oracle Call Interface (OCI). OCILIB is an open source and cross platform Oracle Driver that delivers really fast and reliable access to Oracle databases.
Relational tables if stored locally (vs Excel). Can use ODBC interface to access SQL/Oracle/etc databases. Idiot friendly with drag and drop joins.
Employ the ODBC code or module written for whatever language you're writing in. Or, alternatively, write your own ODBC code.
ODBC and SQL operate at Session Layer.
ODBC stands for Open Data Base Connectivity. It is a connection that is created to define a connection between a computer and a database stored on another system. The ODBC connection contains information needed to allow a computer user to access the information stored in a database that is not local to that computer. You need to define the type of the database application - like Microsoft SQL or Oracle or FoxPro or mySQL. Once you have defined the type of database you need to select or supply the appropriate driver for a connection (Windows already contains many of these) and then supply the name of the database file and the credentials needed to access the database.Once the ODBC connection is created, you can tell specific programs to use that ODBC connection to access information in that database.
In tally ODBC is used to connect to other programs and exchange data dynamically
Alongside dedicated ODBC drivers, a JDCB driver is usually required. This enables a bridge to the ODBC driver, enabling the database to connect to its target.
JDBC - ODBC bridge