Interested to Buy Any Domain ? << Click Here >> for more details...
difference between oracle8i and oracle9i
- 4 Answers
- 9991 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 |
How to select the name of employee who is getting maximum sal with out using subquery
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How to view existing locks on the database?
How to build data dictionary view an new database?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Describe the types of sub query?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What do database buffers contain?
Explain oracle’s server parameter file.
what are stored procedures?
Can objects of the same Schema reside in different tablespaces.?
Oracle General 
