Home » Other » Client Tools » Free tool to browse a database? execute queries? create PL/SQL packages? etc?
Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262891] Tue, 28 August 2007 08:01 Go to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
Hello..

Is there any graphical tool to make queries, browse schemas, program PL/SQL packages and all that basic matters? Something similar to SQLDeveloper provided by Oracle. The problem with this tool is that only works with Oracle 9.2 and later. I have verion 8.

A tool I have tested is a software called TORA but it has a lot of problems, for example, screen refresh is very bad and sometimes it hangs, so I am looking for something better.

Thanks
Jaime
Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262895 is a reply to message #262891] Tue, 28 August 2007 08:08 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There is a freeware version of TOAD available.

Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262902 is a reply to message #262891] Tue, 28 August 2007 08:25 Go to previous messageGo to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
Here are the key limitations in the freeware product:

  • Allows only two concurrent database sessions
  • Save Data limited to first 100 rows only
  • 60 day expiration date
  • Only one active DB session per client
  • Does not permit multiple Toads to run (lacks option)
  • Nag screen upon startup with commercial message
  • Disabled features shown but grayed out (i.e. inactive)
  • SQL Modeler removed


We are looking for something that doesn't expire and that allow to save more than 100 rows.

Jaime
Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262906 is a reply to message #262902] Tue, 28 August 2007 08:34 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The 'Save Data' requirement makes me think you have a specific use in mind rather than a generic evelopment tool.

Are any of these any use?

Link
Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262911 is a reply to message #262891] Tue, 28 August 2007 08:39 Go to previous messageGo to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
There is a common requirement from users. Retrieve some data from the database and export them to Excel. Generally data retrieved is more than 100 rows.

One solution may be decompose the query in subqueries, but this is impractical.

Jaime

Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262912 is a reply to message #262911] Tue, 28 August 2007 08:41 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why can you not use either a SQL*Plus script spooling to a local file, or UTL_File writing to the server to extract the data?

Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262920 is a reply to message #262891] Tue, 28 August 2007 08:54 Go to previous messageGo to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
For productivity reasons. This is a very recurring action.

SQL plus is the last choice to use.

Jaime
Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #262927 is a reply to message #262920] Tue, 28 August 2007 09:08 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SQL*Plus may be the last choice, but it's the last choice on a very short list at the moment.

Do your users need to execute ad-hoc queries, or are there a well defined set of queries with varying parameters?
Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #263324 is a reply to message #262891] Wed, 29 August 2007 13:20 Go to previous messageGo to next message
Jaime Stuardo
Messages: 57
Registered: March 2004
Member
I am using SQL Developer from Oracle. Thanks.

Jaime
Re: Free tool to browse a database? execute queries? create PL/SQL packages? etc? [message #263386 is a reply to message #262891] Wed, 29 August 2007 22:43 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
As they say, whoever "they" are, you get what you pay for :}}
Previous Topic: & sign in where clause
Next Topic: Adding a database to the Oracle Login
Goto Forum:
  


Current Time: Thu Mar 28 08:05:14 CDT 2024