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
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
What is Tax Categories?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
How would you go about increasing the buffer cache hit ratio?
What are different types of transactions in ar? : oracle accounts receivable
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is auto invoicing? Explain : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
Is there any link between pr form(purchse requisition)and po form(purchase order)
HOW TO SPOT AHIERARCHY?
1. What is PO rate variance gain and loss?
as a technical developer in oracle applications which type errors feced in your experience sofar