Re: oracle windows gui for newbie?

On Thu, 18 Dec 2003 09:09:20 -0600, Turkbear <john.g_at_dot.spamfree.com> wrote:

>>I've been told to look at Toad and PL/SQL.

Toad is good, or so I'm told. But Toad and PL/SQL are two different things. Toad is a GUI, and PL/SQL is a programming language. I'm not sure Toad alone will do all you're asking.

I second Alan's comment that you are in for a steep learning curve. Transitioning from MS Access to Oracle is like leaving a paved sidewalk to walk through a swamp, and without a map. Just be prepared for some frustration, and bite off small pieces to learn at one time.

For getting data into Oracle, you might find the following article helpful:

http://www.oracle.com/oramag/oracle/01-sep/index.html?o51o9i.html

First, you'll need to get past the basics of just being able to connect to Oracle using the SQL*Plus command-line client. I recommend learning SQL*Plus. It's a universal constant in the Oracle world.

>> I would appreciate knowing
>>if there are any other friendly GUI tools that would work well for
>>this sort of work, free/open source is fine if there is such a thing
>>available.

There are lots of GUI tools. Quest has some, as do several other companies. I usually use the command-line, and right now I can't seem to recall any of the other GUI tool vendors.

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body. Received on Sat Dec 20 2003 - 18:18:10 CST