difference between oracle8i and oracle9i
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 |
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to use fetch statement in a loop?
What is a data lock in oracle?
Explain about functional dependency and its relation with table design?
What is a static data dictionary in oracle?
What is materialized view in Oracle?
how to insert data into partitioned table partition done by Range partition
How to view the data files in the current database?
what is view?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
How to rename an index in oracle?