Beyond Blog

As you'd expect from the winners of the Specialized Partner of the Year: Business Analytics at the Oracle UKI Specialized Partner Awards 2014, Beyond work with leading edge BI Applications primarily within the UK Public Sector. We intend to share some of our ideas and discoveries via our blog and hopefully enrich the wider discussion surrounding Oracle Business Intelligence and driving improved insight for customers

Using Data Dictionary Metadata in Oracle 12.2 Analytic View Applications

Tuesday, 18 October 2016

John Keymer

SQL

In my previous blog post An Introduction to Analytic Views in Oracle 12.2 I briefly mentioned that one of the killer features of Analytic Views is their ability to hold a huge amount of metadata within the database objects themselves, which can then be accessed and utilized from the application tier. Last time we built up a very simple Employee Sal...

1121 Hits

0 Comments

1121 Hits

0 Comments

Oracle Exadata Express 12.2 - Connecting SQL Developer

Monday, 10 October 2016

Mark Daynes

Other Technical

Oracle Exalytics Express is the first production release of the Oracle 12c release 2 database ( aka Oracle 12.2 ). It comes with some amazing features such as analytic views which we have alr4eady blogged and will be expanding on shortly. As soon as your instance has been spun up you'll want to connect SQL Developer to it, so here's a few hints and...

347 Hits

0 Comments

Tags:

347 Hits

0 Comments

An Introduction to Analytic Views in Oracle 12.2

Saturday, 08 October 2016

John Keymer

SQL

In my last blog post on Oracle Database 12.2 I mentioned the new Analytics View feature. Now in this post I am going to describe the basic structure of what an Analytic View is, and then show an example of creating a very simple one. Note - the Oracle documentation for syntax is very thin at the moment and this information has therefore been taken ...

2412 Hits

0 Comments

2412 Hits

0 Comments

Oracle Database 12.2 Released for Cloud Customers

Wednesday, 28 September 2016

John Keymer

Other Technical

Oracle Openworld 2016 saw the latest Oracle database version announced with immediate availability in the cloud - 12.2. Unfortunately this is not yet available on-premise however a free trial can be obtained over at cloud.oracle.com . This release contains some exciting stuff such as 128 byte identifiers (up from 30), additional approximation aggre...

1109 Hits

0 Comments

1109 Hits

0 Comments

Installation of Oracle Fusion Applications

Thursday, 25 August 2016

John Keymer

Other Technical

Here at Beyond we recently started updating some of our internal test environments. As part of this I embarked on the rather daunting task of installing Oracle Fusion Applications. Daunting because 1) I'm not a DBA and 2) I've never personally done such as installation myself ever before! What could possibly go wrong? We picked up a copy of Pro Ora...

1259 Hits

0 Comments

1259 Hits

0 Comments

Beyond Blog

Using Data Dictionary Metadata in Oracle 12.2 Analytic View Applications

Oracle Exadata Express 12.2 - Connecting SQL Developer

An Introduction to Analytic Views in Oracle 12.2

Oracle Database 12.2 Released for Cloud Customers

Installation of Oracle Fusion Applications

Demonstration

Contact