As I am a newbie to Oracle would like to know besides the 10g database
server, what other I need to download to look at the Oracle 10g ?

How about the something like Form 2000 or Designer 2000 ?

Alan wrote:
> As I am a newbie to Oracle would like to know besides the 10g database
> server, what other I need to download to look at the Oracle 10g ?
>
> How about the something like Form 2000 or Designer 2000 ?
>
>
>
What do you mean "look at"?!?
You got SQL*Plus - Oracle is not a point-and-shoot
Access-like Microsoft product, but a serious beast.
There are numerous tools/programs which allow you to
look to the data within Oracle; Oracle's Enterprise Manager
is (next to the before mentioned SQL*Plus) one of them.

Forms/2000 is a very old version of Developer; Designer/2000
a similar old upper- and lower CASE tool; don't download these
--

Regards,
Frank van Bortel

Alan wrote:

> As I am a newbie to Oracle would like to know besides the 10g database
> server, what other I need to download to look at the Oracle 10g ?
>
> How about the something like Form 2000 or Designer 2000 ?

Depends entirely on what you mean by 'look at'. Looking primarily at the
Oracle-supplied things (which are al described in more detail at
http://otn.oracle.com):

SQLPlus is a powerful access tool that many people disdain because it's
'only command line'. Yet it' built int report layout capabilities will
satisfy a very large chunk of report requirements - assuming fixed pitch
character spacing. Included with the database ...

Oracle's Enterprise Manager provides a number of utilities that help you
look at the database from a monitoring and management perspective. There
are a few things available in OEM that also help access and review the data
itself. IMO it's no longer an option and DBAs and Developers must get to
know this tool if they want to interact with the db (except data) in any
intelligent way. Included with the database ...

Oracle's HTMLDB is a web interface built that can be loaded directly into
the database to provide an Access-like interaction - develop tables,
extract & manage data, etc. Can be considered a bit simplistic, but it's
at the level many (most?) users want. Included with the database ...

Oracle's JDeveloper is the new design and development environment and
includes a whole collection of components to make life easier for
developers, such as UML modelling, wizards, quick start templates, database
table access and pl/sql editor/debugger. Separate product but bundled in
Developer Suite & Application Server as well ...

Developer Suite is the replacement for Oracle Forms & Forms/2000, Oracle
Reports, Oracle Designer [CASE], Oracle Developer, Developer/2000. Has
many, many capabilities (possibly too many) and is seriously mis-understood
by everyone (including Oracle). People tend to specialize in one miniscule
are of it and then compare that area alone to the competition ... in each
area it tends to be 'second best' but it's _the_ 'all-around' collection.
Takes a lot of resources on the developer's environment so it's probably
best to keep the database server and the dev suite on separate boxes. To
get a glimpse of what it accomplishes, go to
http://www.oracle.com/technology/pro...ids/index.html It's a separate
'product' ...

Then there is the plethora of non-Oracle tools and utilities which I ignore.

HTH
/Hans

HansF wrote:
> Alan wrote:
>
>>As I am a newbie to Oracle would like to know besides the 10g database
>>server, what other I need to download to look at the Oracle 10g ?

<snip>
> Then there is the plethora of non-Oracle tools and utilities which I ignore.

TOAD from Quest software is one that's worth not ignoring.

--
//-Walt
//
//

Walt wrote:

> HansF wrote:
>
>> Alan wrote:
>>
>>> As I am a newbie to Oracle would like to know besides the 10g database
>>> server, what other I need to download to look at the Oracle 10g ?
>
>
> <snip>
>
>> Then there is the plethora of non-Oracle tools and utilities which I
>> ignore.
>
>
> TOAD from Quest software is one that's worth not ignoring.
>

OK - you started it... TOAD is an overpriced tool; PL/SQL Developer
is better in support, and supporting new versions, and costs
about nothing ($3K unlimited licence; see
http://www.allroundautomations.nl) and, my favourite, it
has an open interface to which the General Public can
program their own utilities.
And they do - see their web site.
--

Regards,
Frank van Bortel

I agree. We use PL/SQLDeveloper for development. We chose it over
Embarcadero, TOAD and a few others. We've used it for 2 years now and it is
an excellent tool for a great price.

Kurt

--


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com

"Frank van Bortel" <fvanbortel@netscape.net> wrote in message
news:cn0bdf$866$1@news5.zwoll1.ov.home.nl...
> Walt wrote:
>
> > HansF wrote:
> >
> >> Alan wrote:
> >>
> >>> As I am a newbie to Oracle would like to know besides the 10g database
> >>> server, what other I need to download to look at the Oracle 10g ?
> >
> >
> > <snip>
> >
> >> Then there is the plethora of non-Oracle tools and utilities which I
> >> ignore.
> >
> >
> > TOAD from Quest software is one that's worth not ignoring.
> >
>
> OK - you started it... TOAD is an overpriced tool; PL/SQL Developer
> is better in support, and supporting new versions, and costs
> about nothing ($3K unlimited licence; see
> http://www.allroundautomations.nl) and, my favourite, it
> has an open interface to which the General Public can
> program their own utilities.
> And they do - see their web site.
> --
>
> Regards,
> Frank van Bortel

Curiosity got the better of me so I took a quick look - Also on this site is
a tool called Query Reporter that looks like it can kick out reports in
HTML, XML, CSV or TSV format. Anyone have experience in deploying that as a
basic tool for end users, or for batch-type reports? I'm wondering if it's
better than Crystal (I know it won't be as robust as Oracle Reports, but
sometimes that's overkill for the basic stuff).

Craig



On 11/11/04 1:39 PM, in article RKadnSam0rRJLA7cRVn-sw@telcove.net,
"KurtisK" <KJKYLE@COOLBLUENOSPAM.COM> wrote:

> I agree. We use PL/SQLDeveloper for development. We chose it over
> Embarcadero, TOAD and a few others. We've used it for 2 years now and it is
> an excellent tool for a great price.
>
> Kurt
>
> --
>
>
> ----------------------------------------------------
> This mailbox protected from junk email by MailFrontier Desktop
> from MailFrontier, Inc. http://info.mailfrontier.com
>
> "Frank van Bortel" <fvanbortel@netscape.net> wrote in message
> news:cn0bdf$866$1@news5.zwoll1.ov.home.nl...
>> Walt wrote:
>>
>>> HansF wrote:
>>>
>>>> Alan wrote:
>>>>
>>>>> As I am a newbie to Oracle would like to know besides the 10g database
>>>>> server, what other I need to download to look at the Oracle 10g ?
>>>
>>>
>>> <snip>
>>>
>>>> Then there is the plethora of non-Oracle tools and utilities which I
>>>> ignore.
>>>
>>>
>>> TOAD from Quest software is one that's worth not ignoring.
>>>
>>
>> OK - you started it... TOAD is an overpriced tool; PL/SQL Developer
>> is better in support, and supporting new versions, and costs
>> about nothing ($3K unlimited licence; see
>> http://www.allroundautomations.nl) and, my favourite, it
>> has an open interface to which the General Public can
>> program their own utilities.
>> And they do - see their web site.
>> --
>>
>> Regards,
>> Frank van Bortel
>
>

Alan wrote:

> As I am a newbie to Oracle would like to know besides the 10g database
> server, what other I need to download to look at the Oracle 10g ?
>
> How about the something like Form 2000 or Designer 2000 ?

All you need is the database.

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

Walt wrote:

> HansF wrote:
>
>> Alan wrote:
>>
>>> As I am a newbie to Oracle would like to know besides the 10g database
>>> server, what other I need to download to look at the Oracle 10g ?
>
>
> <snip>
>
>> Then there is the plethora of non-Oracle tools and utilities which I
>> ignore.
>
>
> TOAD from Quest software is one that's worth not ignoring.

I don't know ... I've ignored it for years. ;-)

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

Walt wrote:
>
> TOAD from Quest software is one that's worth not ignoring.
>

I bet you didn't pay for your copy of TOAD out of your
own pocket right ?
....stupid Windoz GUI costing an arm.......

To original poster:
For $0...JDeveloper.