Oracle Process Cloud Service is Oracle’s rapid process automation in the Cloud. It is more or less BPM in the cloud. This service allows you to quickly and easily create business processes like you are used to with Oracle BPM, only now in the cloud. In this post I’ll give a quick tour of this service.
So let’s start with the Process Cloud Service. The landing page already gives you loads of features.
The landing (more...)
I’ll prefix this post with a warning. I’ve never done any paid blogging myself, so this is based on emails I’ve received from people requesting me to write for them and from comments I’ve heard from others. With that in mind…
Apart from having adverts on your blog or selling books, there are other ways to earn money from writing. You will have to decide if they suit you.
Paid Articles. Some websites, blogs and magazines pay for (more...)
Editor’s note: Here’s the first post from Osvaldo Villagrana (@vaini11a), one of our AppsLab Mexico team members. Enjoy.
During last week I’ve been playing with Nymi Discovery Kit I got back in our AT&T hackathon participation, and here are my impressions as a developer for Nymi SDK point of view and as a user.
For those who don’t know, this band is wearable biometric identity device that let’s you use your heart’s (more...)
"It seems to me that almost everything is a waste of time."
- Norton Juster, The Phantom Tollbooth
Jonathan Lewis has coined a term and its definition that, I believe, we’ll be using quite a bit:
Stoptimisation - the art of optimisation by not doing the things you don't need to do.
It’s a term we’ve needed for some time now, given the pendulum swing back to the days of yore (meaning pre-9i) with (more...)
Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon.
However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c databases including legacy and container databases.
The following simple SQL and sqlplus techniques can be used to make a “universal (more...)
OBIEE 220.127.116.11 was released this May and Robin and Mark wrote great posts about New Features from System Administrators and the new support for HiveServer2 and Cloudera Impala respectively. In this post, we will see some useful new features for Front-End development. Some of these features like tree map, new styles, etc. were included in the OBIEE 18.104.22.168.10 version, but I’m including them here anyway because if you (more...)
You’ve started a blog. This time next year you’re going to be a millionaire!
If you are interested in making money from a website you can. There are a number of advertising options, with the most popular for the small publishers being Google Adsense. Having said that, you’re going to get a rude awakening when you start earning 20 cents a day.
Advertisers care about reach, so advertising is a numbers game. If you want (more...)
In pre-12c database releases, VARCHAR2, NVARCHAR2 data types were limited to 4000 bytes and RAW data type was limited to 2000 bytes. If there is a need to store more data in VARCHAR2 column, you can in 12c after setting the parameter MAX_STRING_SIZE to EXTENDED. With setting MAX_STRING_SIZE to EXTENDED, you can store up to […]
As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details.
To demonstrate the new behaviour I have used an 22.214.171.124 BP 22 database on Exadata 11.2.3. (more...)
Having published recently two notes
about the Temp Table Transformation highlighting the heuristics based decision and other weaknesses, for example regarding the projection of columns, it's time to publish some more notes about it.The transformation can also have significant impact on cardinality estimates
, both join and single table cardinality.Looking at the difference in the join cardinality estimates of following simple example:
create table t1
rownum as id
, mod(rownum, 10) (more...)
I’m currently doing yet another pass through my whole website correcting broken external links. This is nothing to do with my bad management. This is to do with people changing their URLs and not putting the correct redirects in place. I’ve just done a scan of my website and there are over 800 broken links to Oracle documentation!
There seem to be several ways people deal with URL changes on their website.
I recently ventured down to Mexico to participate in an Internet of Things (IoT) hackathon organized by Laurie Pattison’s (@lsptahoe) Apps UX Innovation Events team with some of my fellow AppsLab members, Luis Galeana, Tony Orciuoli, and Osvaldo Villagrana.
Being the lone non-developer, I wasn’t sure how much I would be able to contribute—but I had done some research pertaining to our use case, so I felt I had at least that much to (more...)
When some of my users were using my system to send emails, they’d often copy-and-paste their messages from their favourite word processor, but when my system sent the emails they’d have question marks dotted around, e.g.
“Why doesn’t this work?”
would get changed to
?Why doesn?t? this work??
Simple fix was to detect and replace those fancy-pants quote characters with the equivalent html entities, e.g.:
function enc_chars (m in varchar2) return (more...)
I was trying to transport a large number of tablespace datafiles from one database to another, and impdp kept crashing with “PL/SQL: numeric or value error: character string buffer too small.”
It turns out there is a limit on what you can put on a single line in a parameter file. Hence if you have something like:
then you might run into trouble. It’s easily fixed however – just put the entries (more...)
At some point during APEX development you may find yourself putting an Oracle APEX page within an iFrame.
Just recently I did just that and came across an error I expected to see, but a little curious as to how it presented itself.
Refused to display '//myserver.com.au/ords/f?p=SAGE:1023:30559832045078' in a frame because it set 'X-Frame-Options' to 'DENY'.
Googling the last half of the message returns some interesting (more...)