GUI-Tool for administration

[Jan Richartz]

Hi,
I'm searching a graphical tool for database administration that's able to
give me the possibility to create queries in a way like in MS Access without
hacking SQL-commands myself.
Does anyone know which tools are available on the market?
Thanks in advance,
Jan

[Daniel Morgan]

Jan Richartz wrote:
Hi, I'm searching a graphical tool for database administration that's able to give me the possibility to create queries in a way like in MS Access without hacking SQL-commands myself. Does anyone know which tools are available on the market? Thanks in advance, Jan

They are undoubtedly out there but as an educator I am intrigued by
why you would prefer a tools that would keep you from learning the
skills that will make you more valuable as an employee and more
employable in the future.

You should be begging for the oppportunity to put away children's toys
and work in SQL*Plus.

No pain ... no gain.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Jarmo]

"Jan Richartz" <jan.richartz@gmx.de> wrote in message
news:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de... Hi, I'm searching a graphical tool for database administration that's able to give me the possibility to create queries in a way like in MS Access
without hacking SQL-commands myself. Does anyone know which tools are available on the market? Thanks in advance, Jan

You should be able to use MS Query if you install (and correctly configure)
ODBC drivers (and their pre-requisites) for Oracle.

[Sean Chang]

Look Query Builder , a component of Oracle Forms 6i.
Don't know how it compares to MS Query.


"Jan Richartz" <jan.richartz@gmx.de> wrote in message
news:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de... Hi, I'm searching a graphical tool for database administration that's able to give me the possibility to create queries in a way like in MS Access
without hacking SQL-commands myself. Does anyone know which tools are available on the market? Thanks in advance, Jan




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[drew]

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1074191169.847209@yasure>... Jan Richartz wrote: Hi, I'm searching a graphical tool for database administration that's able to give me the possibility to create queries in a way like in MS Access without hacking SQL-commands myself. Does anyone know which tools are available on the market? Thanks in advance, Jan They are undoubtedly out there but as an educator I am intrigued by why you would prefer a tools that would keep you from learning the skills that will make you more valuable as an employee and more employable in the future. You should be begging for the oppportunity to put away children's toys and work in SQL*Plus. No pain ... no gain.



Dear Daniel.
When I read a couple of your answers, and just curious why you always
trying to teach people like a Big Dad ?
That group is not your private place, even you are moderating it and
someone is not your student.

What I am trying to say is – just answer a question, otherwise this
will be off topic too, because noone interesting why that person
asking, just what the question is and what is a right answer.

For example, Tom Kyte always respect people, even the person is
stupid.

Sorry, if you feel this like a flame, because it is not - I am very
respect you.

[Daniel Morgan]

drew wrote:
Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1074191169.847209@yasure>...Jan Richartz wrote:Hi,I'm searching a graphical tool for database administration that's able togive me the possibility to create queries in a way like in MS Access withouthacking SQL-commands myself.Does anyone know which tools are available on the market?Thanks in advance,JanThey are undoubtedly out there but as an educator I am intrigued bywhy you would prefer a tools that would keep you from learning theskills that will make you more valuable as an employee and moreemployable in the future.You should be begging for the oppportunity to put away children's toysand work in SQL*Plus.No pain ... no gain. Dear Daniel. When I read a couple of your answers, and just curious why you always trying to teach people like a Big Dad ? That group is not your private place, even you are moderating it and someone is not your student. What I am trying to say is – just answer a question, otherwise this will be off topic too, because noone interesting why that person asking, just what the question is and what is a right answer. For example, Tom Kyte always respect people, even the person is stupid. Sorry, if you feel this like a flame, because it is not - I am very respect you.

I stated an opinion. If you don't like the opinion that's fine. But it
is my opinion and it is here for consideration. Nothing more ... nothing
less.

The one thing you should know is that there are very few organizations
that will hire someone that doesn't know syntax. Not once in an
interview have I, or anyone I know, ever asked a candidate to walk up to
a whiteboard and demonstrate how they use a GUI tool. On the other hand
I have terminated interviews rather abruptly with people that couln't
write an outer join, a correlated subquery, or use a set operator.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Haximus]

"Jan Richartz" <jan.richartz@gmx.de> wrote in message
news:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de... Hi, I'm searching a graphical tool for database administration that's able to give me the possibility to create queries in a way like in MS Access
without hacking SQL-commands myself. Does anyone know which tools are available on the market?

You can use MS Access as an Oracle client, just install the ODBC drivers.

[Turkbear]

"Haximus" <14356256546@spam.org> wrote:
"Jan Richartz" <jan.richartz@gmx.de> wrote in messagenews:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de... Hi, I'm searching a graphical tool for database administration that's able to give me the possibility to create queries in a way like in MS Accesswithout hacking SQL-commands myself. Does anyone know which tools are available on the market?You can use MS Access as an Oracle client, just install the ODBC drivers.
Creating queries is not database administration...

Look into Oracle's Discoverer product ( or a report designer like Crystal)--

For actual database administration use Oracle's tools or a combo tool like T.O.A.D.
( http://www.quests.com/toad/ )

[Daniel Morgan]

Turkbear wrote:
"Haximus" <14356256546@spam.org> wrote:"Jan Richartz" <jan.richartz@gmx.de> wrote in messagenews:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de...Hi,I'm searching a graphical tool for database administration that's able togive me the possibility to create queries in a way like in MS Accesswithouthacking SQL-commands myself.Does anyone know which tools are available on the market?You can use MS Access as an Oracle client, just install the ODBC drivers. Creating queries is not database administration... Look into Oracle's Discoverer product ( or a report designer like Crystal)-- For actual database administration use Oracle's tools or a combo tool like T.O.A.D. ( http://www.quests.com/toad/ )

You won't be doing any database administration in Discoverr or Crystal
either though I suspect they are closer to the mark.

I wonder if what the OP meant to ask was for something that would
perform queries that would answer questions related to administration
.... in which case perhaps they should just go look at OEM.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Jarmo]

"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1074191169.847209@yasure... Jan Richartz wrote: I'm searching a graphical tool for database administration ... They are undoubtedly out there but as an educator I am intrigued by why you would prefer a tools that would keep you from learning the skills that will make you more valuable as an employee and more employable in the future. You should be begging for the oppportunity to put away children's toys and work in SQL*Plus. No pain ... no gain. -- Daniel Morgan

I believe they call that 'preaching', Daniel, not 'teaching'.

[Haximus]

"Turkbear" <john.g@dot.spamfree.com> wrote in message
news:r1bg00tfrshlbaqa9gus3m8nm5qcgd6nup@4ax.com... "Haximus" <14356256546@spam.org> wrote:"Jan Richartz" <jan.richartz@gmx.de> wrote in messagenews:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de... Hi, I'm searching a graphical tool for database administration that's able
to give me the possibility to create queries in a way like in MS Accesswithout hacking SQL-commands myself. Does anyone know which tools are available on the market?You can use MS Access as an Oracle client, just install the ODBC drivers. Creating queries is not database administration... Look into Oracle's Discoverer product ( or a report designer like
Crystal)-- For actual database administration use Oracle's tools or a combo tool like
T.O.A.D. ( http://www.quests.com/toad/ )

No, but then again there is never just one tool that does everything just
the way you like. If the poster wants to create queries "like in MS Access"
then use MS Access. If the user wants to do administration, then do it with
sqlplus or Enterpris Manager (or TOAD). Theoretically you can do anything
you can do with Oracle using these utilities, but then again they are not
the ideal clients for creating drag and drop queries or wysiwig reports or
manually editing data. Use whatever ultility or tool that gets the job done
the way you want to do it, that is my philosophy ;-)

[Turkbear]

"Haximus" <14356256546@spam.org> wrote:
"Turkbear" <john.g@dot.spamfree.com> wrote in messagenews:r1bg00tfrshlbaqa9gus3m8nm5qcgd6nup@4ax.com... "Haximus" <14356256546@spam.org> wrote:"Jan Richartz" <jan.richartz@gmx.de> wrote in messagenews:bu6ffe$cvpqk$1@ID-101303.news.uni-berlin.de...> Hi,> I'm searching a graphical tool for database administration that's ableto> give me the possibility to create queries in a way like in MS Accesswithout> hacking SQL-commands myself.> Does anyone know which tools are available on the market?You can use MS Access as an Oracle client, just install the ODBC drivers. Creating queries is not database administration... Look into Oracle's Discoverer product ( or a report designer likeCrystal)-- For actual database administration use Oracle's tools or a combo tool likeT.O.A.D. ( http://www.quests.com/toad/ )No, but then again there is never just one tool that does everything justthe way you like. If the poster wants to create queries "like in MS Access"then use MS Access. If the user wants to do administration, then do it withsqlplus or Enterpris Manager (or TOAD). Theoretically you can do anythingyou can do with Oracle using these utilities, but then again they are notthe ideal clients for creating drag and drop queries or wysiwig reports ormanually editing data. Use whatever ultility or tool that gets the job donethe way you want to do it, that is my philosophy ;-)

I would agree except for the added overhead of using ODBC to connect Access to Oracle and the differences in Sql code
generated by Access.

[Daniel Morgan]

Jarmo wrote: "Daniel Morgan" <damorgan@x.washington.edu> wrote in message news:1074191169.847209@yasure...Jan Richartz wrote:I'm searching a graphical tool for database administration ...They are undoubtedly out there but as an educator I am intrigued bywhy you would prefer a tools that would keep you from learning theskills that will make you more valuable as an employee and moreemployable in the future.You should be begging for the oppportunity to put away children's toysand work in SQL*Plus.No pain ... no gain.--Daniel Morgan I believe they call that 'preaching', Daniel, not 'teaching'.

No it is called a personal opinion. You just expressed yours so you are
in no position to criticize others for doing the same. Agreed?

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)