QueryTool?

[bengalliboy]

Hi,
All I want to send plain SQL to ORACLE and get the results (Select * TableName). I don't want to install ORACLE Client or anything like that. I am basically looking for some free bees (Thanks In Advance)

 

[rac2]

Use Access as your client and link to Oracle database.

Install ASP and ADO and write a script to connect to Oracle server, submit query, and display results.

Install ActivePerl and write a Perl script to connect to Oracle server, submit query, and display results.

Get free Oracle demo CD and install Oracle, then use SQL*Plus tool to submit queries.

 

[bengalliboy]

Well this looks too complicated than installing oracle client. Why ORACLE don't have some Query tool or third party tools?

 

[Maladon]

If this is too complicated... well anyway
I've done the Access method and it is NOT
complicated. Your machine must have an
alias to point to the Oracle DB.
That's a given so it can't be complicated.
In MSAccess97 ( comes with Office professional)
create a blank database. This is not complicated
since its only a button click and typing in a name.
on the blank window where the tables list will be
is a button marked "new" Clicking it is not
complicated. From the resulting popup list
click "Link Table" and then "OK"
Now you will see the "Link" window.
in the "Files of Type" Drop down box
at the very bottom is: "ODBC Databases"
Clicking that is not complicated either.
From the resulting window choose the
"Machine Data Sources" tab and find the alias
of the Oracle DB you need to connect to. Click "OK"
You will likely need the DB password at this point.
after entering that you will have a listing of
every table in the Oracle DB.
Choose as many as required by hi-lighting them,
you can hi-light as many as desired at one time.
Click "OK" and a link to each will be placed in the
table window.
If asked for a key field for any of these tables
just pick one, it doesn't seem to matter which.
Now you can access the tables as if they were local.