Re: Help needed!

nietfeld_at_cs.tu-berlin.de (Markus Nietfeld) wrote:
>Could anyone please provide me with a summary of the differences between
>Oracle6 and Oracle7?
>
>Thanks in advance,
> Markus Nietfeld <nietfeld_at_cs.tu-berlin.de>

nietfeld_at_cs.tu-berlin.de (Markus Nietfeld) wrote:
>Could anyone please provide me with a summary of the differences between
>Oracle6 and Oracle7?
>
>Thanks in advance,
> Markus Nietfeld <nietfeld_at_cs.tu-berlin.de>

Hi there,

Here are the few differences which striked me while I am posting the repply.

1. Database Triggers
2. Stored Procedures / Packages / Functions
3. Creation of online rollback segments.
4. Multiplexing of on-line redo log files.
5. Block checksum while writing online redo log files into archival files.
6. Referential integrity between tables.
7. Cost based optimizer.
8. DBMS_PIPE to comminicate between 2 oracle sessions.
9. DBMS_SQL (Dynamic SQL in PL/SQL blocks
10. Database roles & profiles.

These are the ones I can think of. There are other benefits. Please refer Oracle 7.x Server Admin guide.

Regards

N.Prabhakar Received on Thu Nov 28 1996 - 00:00:00 CST