gui for sqlplus?

[Nev]

I would like a change from writing sqlplus scripts from the command
line. What do you recomend as a gui. Something that would enable drag
and drop from tables, etc and choosing from drop down menus to
contruct the query. I only extract data - I do no database management
and I think we use oracle 9 or similar. Have windows 2000 and unix on
PCs. would appreciate a fresh view and method.
nev

[Daniel Morgan]

Nev wrote:
I would like a change from writing sqlplus scripts from the command line. What do you recomend as a gui. Something that would enable drag and drop from tables, etc and choosing from drop down menus to contruct the query. I only extract data - I do no database management and I think we use oracle 9 or similar. Have windows 2000 and unix on PCs. would appreciate a fresh view and method. nev

Crystal Reports.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Mark C. Stock]

"Nev" <invalid@powerup.com.au> wrote in message
news:nhd981dd2atkn4fprijsum0k6bbijkqmg4@4ax.com...I would like a change from writing sqlplus scripts from the command line. What do you recomend as a gui. Something that would enable drag and drop from tables, etc and choosing from drop down menus to contruct the query. I only extract data - I do no database management and I think we use oracle 9 or similar. Have windows 2000 and unix on PCs. would appreciate a fresh view and method. nev

have you looked into HTML DB?

[Rauf Sarwar]

Nev wrote: I would like a change from writing sqlplus scripts from the command line. What do you recomend as a gui. Something that would enable
drag and drop from tables, etc and choosing from drop down menus to contruct the query. I only extract data - I do no database management and I think we use oracle 9 or similar. Have windows 2000 and unix on PCs. would appreciate a fresh view and method. nev

PLSQL Developer (Best), Toad (Freeware), For simple queries MS Access.

Regards
/Rauf

[Newsgroups]

Rauf Sarwar wrote: Nev wrote:I would like a change from writing sqlplus scripts from the commandline. What do you recomend as a gui. Something that would enable dragand drop from tables, etc and choosing from drop down menus tocontruct the query. I only extract data - I do no database managementand I think we use oracle 9 or similar. Have windows 2000 and unix onPCs. would appreciate a fresh view and method.nev PLSQL Developer (Best), Toad (Freeware), For simple queries MS Access. Regards /Rauf

also http://www.sqltools.net/

[Sybrand Bakker]

On Sat, 14 May 2005 00:26:19 +1000, Nev <invalid@powerup.com.au>
wrote:
would appreciate a fresh view and method.

Right now you are just soliciting spam.
Please use this groups archives prior to asking any question.


--
Sybrand Bakker, Senior Oracle DBA

[Nev]

On Sat, 14 May 2005 00:26:19 +1000, Nev <invalid@powerup.com.au>
wrote:

Thanks for the help guys.
Nev

[Martijn Tonies]

> I would like a change from writing sqlplus scripts from the command line. What do you recomend as a gui. Something that would enable drag and drop from tables, etc and choosing from drop down menus to contruct the query. I only extract data - I do no database management and I think we use oracle 9 or similar. Have windows 2000 and unix on PCs. would appreciate a fresh view and method.

There's a new one on the block: Database Workbench
www.upscene.com


--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

[Paul]

Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
On Sat, 14 May 2005 00:26:19 +1000, Nev <invalid@powerup.com.au>wrote:
would appreciate a fresh view and method.
Right now you are just soliciting spam.Please use this groups archives prior to asking any question.


??? Seems like a perfectly legitimate question asked in the correct
group (tools) to me.



Paul...


--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, As a courtesy to those who spend
time analyzing and attempting to help, please
do not top post.

[Sybrand Bakker]

On Sat, 14 May 2005 15:32:57 +0100, Paul <paulsnewsgroups@hotmail.com>
wrote:
??? Seems like a perfectly legitimate question asked in the correctgroup (tools) to me.

Just read the response of Martijn Tonies.
The OP's question results in misusing this group for commercial
product announcements.
Commercial products announcements belong in .marketplace.

Apart from that there have been sufficient other individuals, asking
exactly the same question, with identical results.
But evidently the OP is too lazy to search the archives.


--
Sybrand Bakker, Senior Oracle DBA

[Rauf Sarwar]

Sybrand Bakker wrote: On Sat, 14 May 2005 15:32:57 +0100, Paul
<paulsnewsgroups@hotmail.com> wrote:??? Seems like a perfectly legitimate question asked in the correctgroup (tools) to me. Just read the response of Martijn Tonies. The OP's question results in misusing this group for commercial product announcements. Commercial products announcements belong in .marketplace. Apart from that there have been sufficient other individuals, asking exactly the same question, with identical results. But evidently the OP is too lazy to search the archives. -- Sybrand Bakker, Senior Oracle DBA

Sybrand, I understand your point about product announcements and which
NG is the appropriate one for it. Also OP should have googled before
asking such type of question.

However, in this instance there is one distinction... i.e. I only
mentioned the product/s that I had used/use and which one do I prefer.
I do not work for M$, AllRoundAutomations OR Quest. I just use their
products and give my opinion as to which one I prefer. OP can make up
his/her mind afterwards. If I worked for one of these companies then it
would be a different scenrio. I can't speak for others who have
mentioned products in this thread but does not look like they work for
the respective companies either.

Also... when someone says.. I prefer this brand of OS over that or that
brand of hardware over this... that also borders on marketing but we
ignore it in most cases because OS/Hardware is an integral part of how
Oracle runs.

Regards
/Rauf

[Paul]

Sybrand Bakker <gooiditweg@nospam.demon.nl> wrote:
On Sat, 14 May 2005 15:32:57 +0100, Paul <paulsnewsgroups@hotmail.com>wrote:
??? Seems like a perfectly legitimate question asked in the correctgroup (tools) to me.

Just read the response of Martijn Tonies.


He's basically saying, "Take my product for a test drive" and makes it
very clear in his sig that he works for the company in question. The
OP asked about GUI tools for Oracle, it is perhaps not surprising that
Mr. Tonies thinks the one that his company develops is good.


My own opinion is that "spamming" necessitates some level of deceit,
hiding one's bone fides - in essence, being in some way dishonest. Mr.
Tonies was not that, and I (personal opinion here) think that it was
his open honest answer *_relevant_* to the question asked.


If this group was alt.group.cookies.fans and somebody asked "Which
strawberry flavoured cookie is your favourite" and Mr. Tonies had
responed "Well, I like brand XXX, but you might also find our Oracle
tool useful", that *_would_* be spam, but in this context it was a
legitimate reply.

The OP's question results in misusing this group for commercialproduct announcements.

a) your opinion (for which I normally have a lot of respect BTW)

b) not the fault of the OP - if you had an issue with Mr. Tonies, why
not reply to his post?

Commercial products announcements belong in .marketplace.


Agreed. But, see above.

Apart from that there have been sufficient other individuals, askingexactly the same question, with identical results.But evidently the OP is too lazy to search the archives.


Again, another issue. One of the facts of life here on usenet is that
one sees the same questions pop up from time to time (I'm even
thinking of sending a feature request to Agent "Reply (use standard)"
(list createable by user) where "standard" could be)

-------------
What DB are you using?
What OS are your using?
What version are you using?
-------------

another could be

---------------
What has this got to do with Oracle?
----------------

or

----------------
This is spam.
Please post to .marketplace
Please apologise to the group and don't do this again or I will never
consider purchasing your product
------------------

The list could obviously be longer than this.


Paul...




--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.2.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, As a courtesy to those who spend
time analyzing and attempting to help, please
do not top post.