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

What is SQL access advisor in Oracle?

1189

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

How to use "while" statements in oracle?

1326

How to delete a column in an existing table?

1076

How to select all columns of all rows from a table in oracle?

1052

Explain oracle left join with an example?

1011

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2232

What is oracle database 10g express edition?

1118

How to drop an index?

959

What is control file used for?

1209

What is an oracle user account?

990

What happens to the current transaction if the session is killed?

988

Explain the use of consistent option in exp command.

1066

what is the scripts in data base?

2154

Is postgres faster than oracle?

1040