create connection to database in C

Hi,
would like to know how can i implement connection to DB and run a query in C.
also which libraries i need to do it.
thanks

It depends on what database system you have in mind. If you are just experimenting at this point, SQLite is a good introduction.

i am using a load test application called Loadrunner from HP that has C compiler.
my goal is to execute a query to find a specific value and use it aferwards.
i am working with oracle DB.
can you refer to an example of this kind