Interested to Buy Any Domain ? << Click Here >> for more details...
difference between oracle8i and oracle9i
- 4 Answers
- 9941 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 |
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
Can we call a trigger inside a function and function inside a trigger? Give example.
What is an oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
What are the differences between blob and clob in oracle?
What are the different pseudo commands? Explain in general?
why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?
What is the use of Redo Log Information ?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
what is host string in sql plus? how does it related to database?
What does a Control file Contain ?
Oracle General 
