I was looking for a tool to access an Oracle database (the lack of readline support in SQL*Plus is really annoying) and stumbled across tora. I successfully did a "yum install tora" , but I can not access my Oracle database, as expected after reading the following in the RPM description:
Tora ("Toolkit for Oracle") is a GUI-based database development program, offering SQL worksheets and a database browser.
Please note that the Oracle plugin is not shipped.
I can't find any instructions on how to get and/or install the Oracle plugin. Most Google queries I found suggest building tora from scratch, but I'd rather stick with using the RPM if possible. In case it matters, I'm trying to access an Oracle 10g instance that is running on a CentOS 4.4 system.
Are there any other tools people use to access Oracle instead of SQL*Plus? I'll use anything that provides decent command line editing (e.g. readline support) and can automatically figure out the size of my terminal. SQL*PLus is pretty brain damaged in those departments.
Thanks, Alfred
On 10/10/06, Alfred von Campe alfred@110.net wrote:
I was looking for a tool to access an Oracle database (the lack of readline support in SQL*Plus is really annoying) and stumbled across tora.
There are a ton of SQL*Plus CLI replacements with extended functionality on sourceforge/freshmeat IIRC. No first-hand experience but I'm sure some of them are prefectly functional.
http://sourceforge.net/search/?type_of_search=soft&words=sqlplus
Will
On Oct 10, 2006, at 18:28, Will McDonald wrote:
There are a ton of SQL*Plus CLI replacements with extended functionality on sourceforge/freshmeat IIRC. No first-hand experience but I'm sure some of them are prefectly functional.
http://sourceforge.net/search/?type_of_search=soft&words=sqlplus
Excellent, I will check those out tomorrow.
On Oct 10, 2006, at 20:42, Jay Leafey wrote:
Yup, the SQL*Plus editing functions are... awkward, yeah, that's a good word! I looked at Tora, but it was overkill for us. I found a very nice readline wrapper in Perl named uniread (http:// unread.sourceforge.net) that works great for us. As a bonus, uniread is very general and can be used for just about any program that does not support readline editing. I even use it for nsupdate. It's very easy to install, but I wrote a specfile if you want to roll your own RPM.
I'll try this one too.
Thanks!
Alfred
Alfred von Campe wrote:
Are there any other tools people use to access Oracle instead of SQL*Plus? I'll use anything that provides decent command line editing (e.g. readline support) and can automatically figure out the size of my terminal. SQL*PLus is pretty brain damaged in those departments.
Yup, the SQL*Plus editing functions are... awkward, yeah, that's a good word! I looked at Tora, but it was overkill for us. I found a very nice readline wrapper in Perl named uniread (http://unread.sourceforge.net) that works great for us. As a bonus, uniread is very general and can be used for just about any program that does not support readline editing. I even use it for nsupdate. It's very easy to install, but I wrote a specfile if you want to roll your own RPM.
-
Alfred von Campe -
Jay Leafey -
Will McDonald