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 can I convert single byte kana characters into multi byte kana characters and vice-versa.

2390

How can you use check constraints for self referential integrity?

963

What is a nested table and how is it different from a normal table?

1044

Can we use bind variables in oracle stored procedure?

946

What is a read write transaction in oracle?

1083

What are the differences between lov and list item?

1058

How to define default values for formal parameters?

1038

What is a proxy object?

1059

What is raw datatype?

1132

What privilege is needed for a user to connect to oracle server?

987

How to connect to oracle using service name instead of sid?

1015

Is primary key indexed by default in oracle?

981

Explain overloading. Can functions be overloaded?

978

How to use subqueries in the from clause in oracle?

1105

How to connect to a remote server?

1120