Home » SQL & PL/SQL » SQL & PL/SQL » SQL functionality by Oracle Version
SQL functionality by Oracle Version [message #222602] Mon, 05 March 2007 10:48 Go to next message
timboc
Messages: 3
Registered: January 2007
Location: Boston, MA
Junior Member
Is there a website that lists Oracle SQL commands, functions and general functionality by Oracle Version?

For example, I need to know when the rank() function was introduced.

Something along the lines of the "Server Initialization Parameters" by version as maintained in http://www.orafaq.com/parms/ would be ideal.

Thanks,
TIm
Re: SQL functionality by Oracle Version [message #222627 is a reply to message #222602] Mon, 05 March 2007 12:45 Go to previous messageGo to next message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Go to tahiti.oracle.com, pick version and scan New features guide.
If my memory serves me right analytic functions were already in 8i, probably some last versions, but only allowable in SQL, not PL/SQL. Since 9.0 they are allowable also in PL/SQL.
Could be that some Oracle versions introduced new analytic functions as well.

Gints Plivna
http://www.gplivna.eu
Re: SQL functionality by Oracle Version [message #222634 is a reply to message #222602] Mon, 05 March 2007 12:57 Go to previous messageGo to next message
timboc
Messages: 3
Registered: January 2007
Location: Boston, MA
Junior Member
Thats better than nothing but I was hoping that a website already existed which would look similar to Oracles SQL online documentation with less technical details but something along the lines of:

RANK()
Oracle7 - Non existent
Oracle8 - Non existent
Oracle8i - Introduced
Oracle9i - Added functionality to ...
Re: SQL functionality by Oracle Version [message #222636 is a reply to message #222634] Mon, 05 March 2007 13:03 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Yeahh probably it exists but I don't know about it Sad
If you find something, be so kind and post here Smile

Also for 8 and 8i you can check
http://www.akadia.com/services/ora815nf.html
http://www.akadia.com/services/ora8nf.html

Unfortunately haven't found something similar there for later versions.


Gints Plivna
http://www.gplivna.eu
Previous Topic: data model design
Next Topic: constraints
Goto Forum:
  


Current Time: Sat Dec 03 22:38:04 CST 2016

Total time taken to generate the page: 0.08934 seconds