how to use ODBC interface...

[bengalliboy]

I am thinking to write a program in UNIX that can use the ODBC and connect to a remote database and extract data (or generate a quiery that brings results back to host machine)..

Can any one point me to the right direction? Any sample/script will be helpful. Note my source is ORACLE database. TIA

 

[bppbme]

What are you going to write it in?

You could do it in Java, and use JDBC. You may want to look at the JDBC Developer's Guide and Reference (for the 9i version,

http://tahiti.oracle.com/pls/db901/db901.docindex?remark=homepage#index-JDB).

You could use Perl as well, with a database interface module. There are examples on the web.

If it's in C, you may want to check out

http://www.unixodbc.org/

(I haven't tried it though).