difference between oracle8i and oracle9i

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I know if oracle client is installed on windows?

588


what is the difference between restoring and recovering?

630


What is ordinary table in oracle?

738


What is a trigger oracle?

665


How to define an oracle sub procedure?

689






Explain oracle 12c new features for developers?

630


How to invoke the data pump export utility?

656


Explain what are the type of synonyms?

672


What is tns service name?

731


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2255


What is bulk copy or bcp in oracle?

700


Why packages are used in oracle?

640


How to define a procedure inside another procedure?

635


Is oracle an open source?

709


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

615