Oracle 10g connection
Posted on 2006-11-20
I noticed there is quite a lot of discussion but couldnt find exactly what I was after.
I am wanting to connect to an Oracle database, I have the client installed which is Oracle (oraclient10g_home), I also have a view setup and an ODBC connection to that view. I am using Delphi 7 Enterprise and have the DOA40D7 component installed.
I want to query someinformation outof the database. I do not need to write anything back to the database - read only.
What would be the fastest and best way to perform this query?
I was planning to use the DOA components but cant seem to figure them out? although there may be a better way, I am open to suggestions.
Could someone also provide me with some simple code to show how it would work e.g a simple tool to alow me to enter the service name, user and password - this would return a list of tables/views, and also allow me to select one of these and run a select * (or even select count(*) or similar.
thanks for your help