Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w oracle8i and oracle9i
- 3 Answers
- 6451 Views
- iGate, I also Faced
- E-Mail Answers
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
which one is currently in used software cmpanies.
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
how to replace not in with not exist?
What is an Oracle database Partial Backup?
default triggers available for reports
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is the difference between recovery and restoring of the oracle database?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Explain how to close periods in ar. : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
as a technical developer in oracle applications which type errors feced in your experience sofar
