Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg : Difference(s) between Oracle versions --

915396Nov 24 2012 — edited Nov 25 2012
Hi Experts,

Can anybody explain me the difference(s) in Oracle versions - 10g, 11g and 12c ?
With differences, I'm mainly concerned about the new SQL and PL/SQL functionalities.

Any reference material links?

Thanks In Advance,
Ranit B.

Edited by: ranit B on Nov 25, 2012 8:23 AM
-- edited from 12g to 12c [pointed by user 11g]
This post has been answered by Srini Chavali-Oracle on Nov 24 2012
Jump to Answer

Comments

Srini Chavali-Oracle
Check the New Features Guide

11gR1 - http://docs.oracle.com/cd/B28359_01/server.111/b28279/toc.htm
11gR2 - http://docs.oracle.com/cd/E11882_01/server.112/e22487/toc.htm

HTH
Srini
915396
Hi Srini,

This is indeed helpful... Thanks a ton!!
But, example like PIVOT was added in v11.1

So, where can i find details and new clauses added like this?
Srini Chavali-Oracle
Answer
Check the "What's New" section in the SQL Language Reference Guides

11gR1 - http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm
11gR2 - http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm

HTH
Srini
Marked as Answer by 915396 · Sep 27 2020
915396
Thanks a lott .. Srini.
Exactly what i wanted.
damorgan
Well the Oracle docs are a good start ... but hardly complete. This may help.
11.2.0.1 - http://www.morganslibrary.org/reference/new_in_11gR2.html
11.2.0.2 - http://www.morganslibrary.org/reference/new_11_2_0_2.html
11.2.0.3 - http://www.morganslibrary.org/reference/new_11_2_0_3.html

and I am working on one for 12.1.0 that I will publish as soon as the product is released.
1 person found this helpful
23ai
Looking at the first post, OP mentioned 12g?

It is good to know if it is called 12g but looks like it will be 12c?????
EdStevens
11g wrote:
Looking at the first post, OP mentioned 12g?

It is good to know if it is called 12g but looks like it will be 12c?????
But until it is officially released, the only people who know the answer to the OP's question -- as it relates to 12whatever -- are under nondisclosure agreements.
damorgan
Those of us in the Beta have signed an NDA and can only disclose that which was put into the public sector by Oracle Corp., for example at OpenWorld, which isn't much.

But even when Oracle publishes its "New Features" documentation it will be incomplete as the links I posted demonstrate with respect to earlier versions and my lists are incomplete as well.

But as to 12g or 12c ... count on the "c" though it is never too late for Oracle to change its mind about the name, the feature set, or anything else. And that is why all of us, even Beta testers, must wait for the release of 12cR1 to know what is really in it ... and what it is called.
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 23 2012
Added on Nov 24 2012
#general-database-discussions
8 comments
2,180 views