what is the difference b/w oracle8i and oracle9i
Answer Posted / 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 View All Answers
how to replace not in with not exist?
can we use lexical perameter in oracle plsql if yes how
What is the importance of batch source set up in ar? : oracle accounts receivable
How to clone the database using RMAN back
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
What is autocashrule set? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
A scenario for amount correction & how to use amount correction functionality in AP invoices
Differentiate between transaction type and transaction source? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain prerequisites and post activities of oracle database installation
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the use of lockboxes? : oracle accounts receivable
Explain accounting for invoice in advance and arrears. : oracle accounts receivable