difference between oracle8i and oracle9i
- 4 Answers
- 9217 Views
- NIIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
merge is a command which is used to both insert and delete.
timestamp datatype is introduced.
max no of columns in 8i is 256 where as in 9i we can have
999.
on delete set null supports only in 9i.
by using this, when we delete the parent record the child
records are replaced with null values
| Is This Answer Correct ? | 11 Yes | 7 No |
Answer / ramprasad.s
Hi
Oracle 9i has the advatantage over Partition Table.
bye
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 8 Yes | 5 No |
Answer / anjali
1) u have automatic undo management.
2)u have automatic segment space management
3)u got these locally managed tablespaces which is better
than the dictionary managed tabespaces as u can avoid
fragmentation with locally managed tablespaces.
4)u have a new dbms_metadata package to extract object
definitions from database.
5)multi table insert is possible with 9i
6)importanly u have this spfile in 9i.
7) also u have dynamic memory mangement facility with 9i.
8) u have tuning advisories with 9i.
9) u have multi block size parameter with 9i and many more
features like these
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / lokanath
In Oracle 9i Natural Join,
ON clause,
Using all are added.
COALESCE Function is added.
MERGE Statement
and few more features are added.
| Is This Answer Correct ? | 6 Yes | 5 No |
What privilege is needed for a user to create indexes in oracle?
What is a cursor in oracle?
What is logical backup in oracle?
How to retrieve data from an cursor to a record?
How to join two tables in a single query using oracle?
What is the difference between SQL and SQL Server?
How to run queries on external tables?
What is the purpose of save points in oracle database?
State and explain the different types of data models?
Can we protect our pl/sql source code?
How do I reset a sequence in oracle?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
Oracle General 
