My personal favorite is Oracle Express Edition (XE), the free version of the world's best relational database.
Here's what's great about it:
Read and monitor Oracle related blogs and news sources, all in one place.
This is my contribution to the OTN Appreciation Day, which was initiated by Tim Hall.
One of my favorite features of the Oracle Database are Analytic Functions. They were introduced with Oracle Database 8.1.6 Enterprise Edition, and have been in the Standard Edition since version 9.
With analytic functions you can add inter-row calculations, aggegrate over multiple dimensions, rank assignments based on values. All this without a GROUP BY clause.
The syntax might (more...)
Oracle Developer Cloud Service 16.4.1 has a fresh new UI and over 30 new features and improvements.
New Navigation List
Developer Cloud Service includes a more convenient vertical navigation list. Some features like the Maven repository browser have been moved to top level of the navigation list. The navigation list is collapsible to save on horizontal space when you are working with a specific feature area. The Home tab which shows (more...)
Oracle OpenWorld2016 was a giant success for AuraPlayer! The response to our solution was amazing. Flocks of people gathered at our booth for live demos, attended AuraPlayer CEO Mia Urman’s session on Digital Transformation, gathered at Grant Ronald’s talks on “Forms to Mobile without writing a single line of code,” and heard first hand from AuraPlayer customer Rogers Group Inc. how fast and easy it is to create apps from their EBS modules to deliver (more...)
Normally when you use a Breadcrumb in an APEX application you enter the data and that's it. The breadcrumb will look something like this:
It's trivial to replace the text that you enter in the Breadcrumb with a little bit of markup and show a Font Awesome (or with APEX 5.1 Font APEX) icon.
Now the text will be (more...)
<span class="fa fa-home"></span>
blog Abhishek Gupta-Oracle shows you how to include unit testing as part of your build process and how to see the results in your dashboard.
Learn more here:
We have bought an application that runs on an Oracle database. There are triggers defined on the tables, but we want to add our own code to these triggers, but we don’t have access to the source code. What is the approach we should follow to accomplish this?
There are two types of DML triggers. Statement level triggers and row level triggers. Then for these two types there are (more...)
Oracle 12c introduced the ability to specify sequence.nextval as the default on a column, which is really nice – including the fact that it eliminates one of your excuses why you don’t decommission those old triggers.
Unfortunately it doesn’t work as you might expect if you use an
INSERT ALL statement; it evaluates the default expression once per statement, instead of once per row.
create sequence test_seq; create table test_tab ( id number default (more...)
Recently I heard someone talk about overloading in Java. What is it, is it possible in PL/SQL and if so, how would I use it?
Overloading is a technique of creating multiple programs with the same name that can be called with different sets of parameters. It is definitely possible to apply this technique in PL/SQL, in fact, Oracle does this a lot of times in their own built-in (more...)