For who is PCS?
Oracle Process Cloud Service is a PaaS (Platform as a Service) offering which centers around designing and managing (stand alone) business processes in the cloud. The focus is once again on business analysts and other non-technical people to automate business processes. Oracle has keyed them “citizen developers”. One of the features is the option to create forms that fulfill the “human task” interaction in the BPM process.
A walkthrough for creating (more...)
In this post I walk through what it would take to access Oracle 12c using a spring boot application deployed to Pivotal Cloud Foundry PCF all from my Macbook Pro. Of course this can be done outside of an isolated laptop like my Macbook Pro but handy while doing DEV/TEST and still being able to use Oracle 12c.Requirements
- Oracle 12c instance
- Git Client
1. First you will need a 12c Database and the (more...)
And here we are. The last day of Oracle OpenWorld 2016…
The first session I went to was a panel session called “Thinking Clearly About Database Application Architecture” with Gerald Venzl, Bryn Llewellyn, Connor McDonald, Toon Koppelaars, Cary Millsap. The session started with an introduction by Toon, explaining how the thick database architecture model is provably superior to the thin database model, especially from a performance perspective. I am definintely in (more...)
I mean, in principle it’s not that special, being that the info is already on…
Thank you for coming to my session Preventing Bad SQLs at Oracle Open World despite being at lunchtime on the last day.
Congratulations to the winners of my book.
Download slides here http://bit.ly/2cGJqR7
As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool version, the downside is that is currently available on Oracle cloud only. We are all waiting for the on-premise release so we can install and … Continue reading Oracle 12.2 Cool New Features
Earn a core OCA credential on your path to Database Administrator or PL/SQL Developer certifications, by passing exam 1Z0-071 Oracle Database SQL.
Released earlier this year, this certification fills a gap in the offerings that fulfill the SQL prerequisite in core Database Administrator and PL/SQL Developer paths. Until now, these offerings included two non-proctored SQL fundamentals exams (1Z0-051 and 1Z0-061) that do not result in certification by themselves and a more in depth SQL Expert (more...)
The new version of OBIEE 12c, 22.214.171.124 to be exact, is out, so let’s talk about it. It’s my intent that after reading this, you can expect some degree of comfort in regards to possibly doing this thing yourself (should you find yourself in just such a circumstance), but if not, feel free to drop us a line or give us a ring. It should be noted that Oracle documentation explicitly (more...)
I have been working with BI Applications since OBIA switched to ODI in version 126.96.36.199.0. I have installed and worked with all of the 11.x versions using several different sources. This most recent version of OBIA may only be a Patch-Set release, but it has some new features that make it very compelling; ETL automatic error handling, Health Check, ETL Diagnostics, and built in Email notifications.
If you've been using (more...)
Yesterday was the last day of the Java Hub. Highlights
include the Java Community BBQ, JavaOne4Kids, Community Demos, and Live
Streaming discussions each day. If you missed some of the live streaming, visit
the Nighthacking video channel.
... [Read More
Fall is here and today is the last day of the Oracle OpenWorld 2016. It had been an amazing 5 days for our customers, partners and us. If you missed the keynotes, you can watch them on-demand. There are still two great sessions from Oracle Linux and Virtualization teams:
Hands-on Labs: Systems Management with Spacewalk [HOL6546]
8:00 a.m. | Hotel Nikko - Carmel (3rd Floor)
Avi Miller, Oracle
Oracle Linux includes support for (more...)
Frequently when developing Spring based applications, I will use the H2 in memory database during your development process. H2 ships with a web based database console, which you can use while your application is under development. It is a convenient way to view the tables created by Hibernate and run queries against the in memory database. In this post I show what is required to set this up as well as what it means to (more...)
In this article, I’ll explain what the NEW_TIME function does and show you some examples. Purpose of the Oracle NEW_TIME Function The NEW_TIME function converts a date from one timezone to another timezone. Syntax The syntax of the NEW_TIME function is: NEW_TIME ( input_date, timezone1, timezone2 ) Parameters The parameters of the NEW_TIME […]
Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help?
Erik van Roon
Let’s start with explaining a bit what table functions are. Table Functions are functions that return a collection of (more...)
This is my last post of the year.
Strangely this was the year with less posts here in Oracle Radio. And not only that, but I started to do it in English.
2007 I’ve been feeding this blog in Spanish, but for some specific
posts I just decided to do it in English to get to a greater audience.
So what about to upgrade to Oracle SOA Site 12.2.1? Is the name (more...)
Don’t forget Oracle Midlands Event #17 next week!
I don’t know about you, but I would like to know what Oracle have been up to. There has been very little in the way of publicity from them recently…
If you live near, please show your support for the event and come along. It’s free thanks to the sponsorship by RedStackTech.
Oracle Midlands : Event #17
was first posted on September 22, 2016 at 7:41 am.
I started the day by meeting up with a bunch of people at the Dbvisit breakfast. This has become a regular event over the last few years. Followers of the blog know I like the Dbvisit folks and they tend to attract people I find fun and interesting. After food, loads of coffee and interesting conversation, it was time to head across to the conference.
I bumped into Liron and Zohar at the OTN lounge and walked over with them to watch Connor (more...)