Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w oracle8i and oracle9i
- 3 Answers
- 6275 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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
can u give guidance abt packages of plsql
what is semphore explian it?
3. Steps in UAT?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Explain prerequisites and post activities of oracle database installation
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What is the disk migration? what is the steps involved in oracle disk migration?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
what are basic modules required to implement oracle application in any oraganisation?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
