DIFFERENCE BETWEEN ORACLE 8i & ORACLE 9i

[VIKAS17786]

COULD YOU EXPLAIN ME WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ...........................

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU.............

[pks00]

COULD YOU EXPLAIN ME WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ...........................

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU.............

Oracle 8i and 9i are different versions of the database. Oracle9i is a newer release to Oracle8i, it will have more enhancements, fixes etc. New features are available to both developers and administrators.

With Oracle each new version contains the same functionality as the previous version. So Oracle 9i is backwards compatible with 8i. Oracle 9i does many things differently internally so they are not exactly the same database engine. And Oracle 9i has a host of new features designed to make the database more stable, easier to manage and increase functionality. There are so many new features that Oracle Corp. provides a complete manual listing these new feature. The Oracle 9i New Features manual can be found on Oracle's Technet site at if you are interested. You will need to register for a free account if you want to view documentation on that site.



DBMS/RDMBS -
read this http://www.faqfarm.com/Q/What_is_the_difference_between_DBMS_and_RDBMS

[23prabu]

WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ...........................

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU............

[amitpatel66]

WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ...........................

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU............

Your Question is very theoritical and is out of scope of this forum to answer. You can go through some good oracle book or google out some materials for theoritical questions.

[smruti]

WHAT IS DIFFERENCE BETWEEN ORACLE 8i AND ORACLE 9i ? ...........................

ALSO WHAT IS DIFFERENCE BETWEEN DBMS AND RDBMS ? .....

I WOULD BE WAITING FOR THE ANSWERS.
THANKYOU............

oracle8i
1) only rbo(rule base optimizer)
2)no merge statement available
3)no full outer join available
4)no timestamp datatype available
5)sql and pl/sql engine are different engine.

Oracle9i
1)both RBO and CBO(cost base optimizer)
2)MERGE is there.
3)FULL OUTER JOIN is there
4)TIMESTAMP is there
5)SQL AND PL/SQL ENGINE IS INTEGRATED INTO SINGLE ENGINE


Dbms
1)In dbms relationship between tables maintained programatically
2)not secure
3)doesn't support client server architechure.
4)satishfy 5/6 codd's rule.


RDBMS
1)In RDBMS relationship between tables maintained at table creation
2)Secure becoz we can login into a OS promth.
3)Support client server architechre
4)Satishfy 9/10 codd's rule.