In Oracle 9i Natural Join, ON clause, Using all

difference between oracle8i and oracle9i

Question Posted / lokanath

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

Please Help Members By Posting Answers For Below Questions

How to load a large xml file?

788

What are triggers in oracle?

745

Explain coalesce function?

813

Please explain oracle left join with an example?

750

What is transaction control statement and how many types of transaction control statement in Oracle?

792

What is tns service name?

805

How can windows applications connect to oracle servers?

695

What is materialized view in Oracle?

807

What are the most common interview questions on ETL Testing for experience?

828

How to define a specific record type?

806

Explain the use of parfile option in exp command.

719

Difference between inner join vs where ?

771

How remove data files before opening a database?

743

How to invoke the data pump export utility?

752

How to start your 10g xe server?

765