Re: what needed to start programming with Oracle

ramon a écrit dans le message
<172d2854.fa34effb_at_usw-ex0105-040.remarq.com>...
>- first of all, how do I design the structure and properties of
>the tables? can be done also with Developer?

No, you need tools like Oracle Entreprise (available on your Oracle database cd)
or command line in SQL/PLUS (a kind of text terminal to the database) to create your tables.
There is analyse or designing tools too like Oracle Designer/2000, PowerDesigner.
You can use it to design the database and they generate the creation script for your tables.

>- the tables and forms & reports must all be in the same file?

Tables are in datafile (something like an Access file but contening only tables, views, indexes, stored program units) and forms/reports are store on your hard disk or on a file server.

>- does Developer create an standalone .exe file that users can
>execute to print the reports and graphs, or do the users need to
>have an aditional oracle-tool installed on his PC?

No, you need a runtime tools. The runtime tools is a component on the DEV/2000 cd.
It's a part of the package. The deployement of the runtime is free.

>- which is the typical scheme?:
>A computer used as Server containing the data file, and then
>each user having on his PC the program created with Developer?
>Does the server-computer need some oracle-tool or it is enough
>to copy the data file there?

Oracle is a database server ... so to have an Oracle database up and [Quoted] [Quoted] running, you need an Oracle server. The server receive request from clients and send results, manage the growing of table, locking of records, transactions,
security,... Database is acceded by client pcs runnin SQL/NET itself using various communication protocol like TCP/IP, IPX/SPX. That's for the database itself. It's the same whatever the tools you use to exploit it: Dev/2000, delphi or other tools. For DEV/2000, the runtime software must be install on each user's pc but you can leave the forms and reports on a file server or put them on the user's pc.

>If you don't want to answer my questions, please, suggest me a
>good book or any other thing that helped you to start in the
>Oracle-world.

The world of true relational database like Oracle, SQL Server, Informix and other is quiet different of the Access concept. There is the database administration, users management, stored program units, optimizing process, configuration and many more. Access is just a toy for small business. So my advice is : fellow formations in the Oracle company. There is formation about Oracle database administration, Oracle Database programing (for stored porgram unit and PL/SQL programing), DEV/2000 and so on. Don't worry it's not really difficult, it's just new concepts but so powerful.
For the books, you'll see after what can be useful for you but I'll give you a title tomorrow.

Welcome to the true relational database world and the best one: ORACLE

Luc Bosman
DEV/2000 Software Engineer
Database and Network Administrator
IILE-SRI
rue Ransonnet, 5
B-4020 LIEGE
BELGIUM
l.bosman_at_wanadoo
ICQ 37011625 http://users.skynet.be/kobukai/

|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
----------------------------------------------------