Home » SQL & PL/SQL » Client Tools » Is there any tool to build Oracle queries?
Is there any tool to build Oracle queries? [message #376969] Fri, 19 December 2008 04:58 Go to next message
angeline12
Messages: 1
Registered: December 2008
Junior Member
Hi,

I am looking out for some tool which can build sql queries. This tool would mainly be used by people who don't know to write sql queries.
So do we have a tool which:
1) has simple front end which can connect to oracle database.
2) displays names all the tables that are there in that perticular schema.
3) once we select the table name it will show column names for this table in another drop down on same page.
4) we can then simply select from these columns give where condition and tool will also display output of that query

We have oracle 9i DB, do we have some tool which is compatible with it, and can give us above mentioned functionalities..

Thanks
Re: Is there any tool to build Oracle queries? [message #376976 is a reply to message #376969] Fri, 19 December 2008 05:22 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Have a look at Oracle Discoverer.
Previous Topic: is there any shortcut to open the SQL* PLUS editor using Toad??
Next Topic: Export data into excel file
Goto Forum:
  


Current Time: Wed Dec 07 12:28:06 CST 2016

Total time taken to generate the page: 0.11365 seconds