Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w oracle8i and oracle9i
- 3 Answers
- 6270 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
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
What is Restricted Mode of Instance Startup in Oracle?
Differentiate between transaction type and transaction source? : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
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
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
How would you go about increasing the buffer cache hit ratio?
What is autocashrule set? : oracle accounts receivable
What are different types of transactions in ar? : oracle accounts receivable
where the dff data will be stored
Explain about party and customer in ar : oracle accounts receivable
