Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w oracle8i and oracle9i
- 3 Answers
- 6317 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
Can we modify approve purchase order?if yes what is navigation?
how can we send a concurrent program output to the clients through mail or fax give me example.
I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC
HOW TO SPOT AHIERARCHY?
What background process refreshes materialized views?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
what is different between inline query,subquery& corelated query?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
How would you determine the time zone under which a database was operating?
What is db_recovery_file_dest in oracle? When do you need to set this value?
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
Oracle General 
