5

The Oracle Database Features Site – reducing Oracle Documentation Drudgery

 1 year ago
source link: https://mikesmithers.wordpress.com/2023/06/21/the-oracle-database-features-site-reducing-oracle-documentation-drudgery/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

The Oracle Database Features Site – reducing Oracle Documentation Drudgery

If there’s one thing Teddy approves of it’s eating you’re own Dog Food…although, he does appreciate the value of a varied diet…

teddy_sandwich.jpg?w=703

Some nameless heroes in the Oracle Documentation Team seem to agree and have produced a publicly available APEX application which allows you to search:

  • the features available in each successive Oracle release
  • the various licensing options and packs available with each Edition

Time to head on over to the Oracle Database Features site and take a closer look…

Features

I’ve heard a fair bit about schema only accounts. I wonder when they came along ?

schema_only_accounts_search.png?w=1024

It looks like they have been around since 18c with further enhancements in later releases.
If I want details on a particular listing, I can just click on the title :

schema_only_accounts_details.png?w=1024

As you can see, there’s also a link to the relevant documentation.

It’s also possible to do a less specific search. For example, if I’m looking to upgrade from 11.2 to 19c and I want to see all of the new features in all of the intermediate releases :

new_features_12_to_19.png?w=1024

The application also allows you to focus on areas of interest.
For example, If I want to see what’s new in 21c as far as Analytic Functions are concerned,
I can choose Data Warehousing/Big Data as my focus area then further refine my search by specifying Analytic Functions as the Sub Area of Interest.
Together with checking 21c as the Version and that I’m interested in New features only, the Application returns this :

21c_new_analytic_functions.png?w=1024

Limitations

It’s worth noting that the information in this application is based on the New Features documentation for the respective Oracle versions. Therefore, whilst you’ll find an entry for the VALIDATE_CONVERSION SQL function, introduced in 12.1…

standard_hash.png?w=1024

Licensing

Selecting the Licensing tab reveals functionality for navigating the often complex area of Oracle Licensing.
For example, if we want to find out which Editions Partitioning is available on :

partitioning_search.png?w=1024

Once again, further details are available by clicking on the title of a result row :

partitioning_details.png?w=1024

The Oracle Database Features site is a welcome augmentation to the existing documentation.
It’s categorised and searchable content offer the potential for significant saving in time and effort, especially when you’re preparing to move between Oracle versions.

Loading...
9b3f1c72f7506288479c021b361774553929d2c0e2eda91a4997a66e8e01acd9?s=42&d=https%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D42&r=G

Author: mikesmithers

Back in 1993, I discovered that I could get paid money for doing fun stuff with computers. Over the years, I've specialised in Oracle Databses as a developer, a DBA and sometimes, an architect. It's my evil alter-ego - The Antikyte - who writes a blog about my various technical adventures. Yes, that is his Death Star parked in the Disabled Bay. I currently live in the South-West of England with Deb, my long-suffering wife. View all posts by mikesmithers


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK