difference between oracle8i and oracle9i

Answers were Sorted based on User's Feedback



difference between oracle8i and oracle9i..

Answer / kalpana

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

difference between oracle8i and oracle9i..

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

difference between oracle8i and oracle9i..

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

difference between oracle8i and oracle9i..

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

Post New Answer

More Oracle General Interview Questions

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

1 Answers  


What is connection pooling in oracle?

0 Answers  


What is dynamic proxy?

0 Answers  


what is pragma?

2 Answers  


how to get count of tables in particular database in Oracle?

3 Answers  


Explain the difference between replace() and translate() functions in oracle?

0 Answers  


WHAT IS ecc 6.0

0 Answers  


What is a read write transaction in oracle?

0 Answers  


Explain what are the different type of segments?

0 Answers  


structural difference between bitmap and btree index ?

1 Answers   Infosys,


What are triggers?Where are they used?

3 Answers  


difference between truncate and delete ,drop?

3 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)