Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!nrl-cmf!ukma!tut.cis.ohio-state.edu!ucbvax!decwrl!sun!pitstop!sundc!seismo!uunet!mcvax!unido!tub!astbe!ber
From: ber@astbe.UUCP (H.Bernau)
Newsgroups: comp.databases
Subject: Re: Information on ORACLE
Message-ID: <503@astbe.UUCP>
Date: 7 Feb 89 06:49:36 GMT
Reply-To: ber@astbe.UUCP (H.Bernau)
Organization: GEI Software Technik Berlin, Germany
Lines: 56

Hi Ron !
Sorry that I am posting but our local sendmail doesn't understand the 
net adresses you gave in your article

In article <sXtwIRy00Ui083GUcA@andrew.cmu.edu> you write:
>What application development tools are included with the DBMS.  Are the
>development tools easy to use?  Specifically, how easy is it to create
>tables, relationships, data entry constraints, data entry forms, reports,
>menus, and views.
>
There are: SQL*Forms, a window oriented designer tool for forms apllications
	   SQL*Menu, a window oriented designer tool for menu apllications
	   SQL*Report, a window oriented designer tool for reports
           SQL*Calc, a spreadsheet tool similar to LOTUS123
Views are created using SQL !
There is no possibility to define (logical) relationships between tables or to
define constraints in version 5. I don't know the enhancements of V6.

>Does ORACLE provide a code generator?
What do you mean ? Code generator for what ?

>How does it handle maintenance (backups and recoveries)?
You can do After Image Jounalling, Export/Import, file backup.

>How easy it is to change the structure of a database?
ORACLE's using SQL so that you can do an ALTER TABLE to modify existing field
or to add some new ones.

>Is there a data dictionary subsystem?  If so, how is it accessed?  Is
>access restricted to the DBA (and other authorized personnel), or can
>anyone access it?
There is one and anyone can access it if the DBA gives them the autorization
to do so. The DD can be accessed like all (!) other database tables using SQL.

>How well does ORACLE manage memory space?  Disk space?
What do you mean with "how well does ..."? I don't think that there is a need
to know it.

>What kind of query system is provided, and how easy is it for a
>non-programmer to use?
SQL and SQL and SQL and SQL !!!

>Thanks to all who respond.
>Ron Daubel
T'was a pleasure for me !

For more information contact ORACLE Corp. They are on the net (news@oracle I
think).

-------------------------------------------------------------------------------
|   Rolf Bernau               |
|   GEI Software Technik mbH  |  Berlin:             astbe!ber
|   Hohenzollerndamm 150      |  USA:                ...!pyramid!tub!astbe!ber
|   1000 Berlin 33            |
|   West-Germany              |
-------------------------------------------------------------------------------