what is the difference b/w oracle8i and oracle9i

Answers were Sorted based on User's Feedback



what is the difference b/w oracle8i and oracle9i..

Answer / esakkiraja

Difference between 8i and 9i:

8i:

It was developed in 1997 and it supports the object
oriented development and multimedia application and in the
8i--I stands for Internet


9i:

It was developed in 2001 and 400 new features has been
included in 9i and it has the facility of reading anbd
writing the xml data from outside and it has the option for
Oracle RAC

Is This Answer Correct ?    3 Yes 0 No

what is the difference b/w oracle8i and oracle9i..

Answer / bindu

Oracle 9i is an upgrade version of Oracle.It offers lot of
new and additional features, which are not available in
oracle 8i.It offers, new features to both
developers and administrators.Oracle 9i is the obvious
choice.
Like: 8i introduced a number of features in SQL that could
not be used in PL/SQL. Since we went to 9.2 it's been great
to be able to use MERGE INTO, CASE and analytic functions
within PL/SQL packages.

A lot of little things are improved in PL/SQL, such as CAST
now being implicit in many situations when you used to have
to code FROM TABLE(CAST(table_expression AS
some_array_type) - you can now use FROM TABLE
(table_expression). Also INDEX BY collections (associative
arrays) can now INDEX BY other types besides BINARY_INTEGER
(e.g. PLS_INTEGER, VARCHAR2).

In 9i you can use locally managed tablespaces for every
tablespace including temp, rollback and system, while in 8i
you were limited to regular data/index tablespaces. You
also get automated undo management which is worth taking a
look at (for example you can configure it to hold onto
rollback blocks for longer, which could potentially help
reduce ORA-01555 Snapshot Too Old errors).

Is This Answer Correct ?    2 Yes 0 No

what is the difference b/w oracle8i and oracle9i..

Answer / bindu

Oracle 9i is an upgrade version of Oracle.It offers lot of
new and additional features, which are not available in
oracle 8i.It offers, new features to both
developers and administrators.Oracle 9i is the obvious
choice.
Like: 8i introduced a number of features in SQL that could
not be used in PL/SQL. Since we went to 9.2 it's been great
to be able to use MERGE INTO, CASE and analytic functions
within PL/SQL packages.

A lot of little things are improved in PL/SQL, such as CAST
now being implicit in many situations when you used to have
to code FROM TABLE(CAST(table_expression AS
some_array_type) - you can now use FROM TABLE
(table_expression). Also INDEX BY collections (associative
arrays) can now INDEX BY other types besides BINARY_INTEGER
(e.g. PLS_INTEGER, VARCHAR2).

In 9i you can use locally managed tablespaces for every
tablespace including temp, rollback and system, while in 8i
you were limited to regular data/index tablespaces. You
also get automated undo management which is worth taking a
look at (for example you can configure it to hold onto
rollback blocks for longer, which could potentially help
reduce ORA-01555 Snapshot Too Old errors).

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle AllOther Interview Questions

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,


Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


How can you gather statistics on a table?

3 Answers  


How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

2 Answers  






When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  


What do you mean by Oracle MEDIA RECOVERY?

0 Answers  


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

0 Answers  


What command would you use to create a backup control file?

1 Answers  


as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,


What is the sql query to find the employee who has Nth maximum salary?

2 Answers  


What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)