Hi everyone! Mia has been hustling to prepare for her upcoming events and, as a result, struggling to keep the blog as updated as she would like. So, this is Jackie, Auraplayer’s Marketing Manager, serving as her stand-in blogger for the time being. Let’s hope I can do her justice
It’s that time of year again; ODTUG’s 2015 KScope Conference is less than a month away. This year’s conference will be held from June 21-25 in Hollywood, Florida, at the (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...)
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...)
Today is friday and I like the twitter-hashtag #FibonacciFriday,
so I tweeted
Don’t be afraid of having a look at the wikipedia-site, the math is not complicated at all ( you don’t need more than adding natural numbers smaller than hundred ), nevertheless the theorem is nice from a (more...)
Last week, I wrote about how to use
bash arrays and the MySQL database to create unit and integration test scripts. While the MySQL example was nice for some users, there were some others who wanted me to show how to write
bash shell scripts for Oracle unit and integration testing. That’s what this blog post does.
If you don’t know much about bash shell, you should start with the prior post to learn about (more...)
Kscope15 is insanely close and I'm very excited to be making the journey this year.
A few months ago I made a list of presentations that piqued my interest to try encourage a business colleague to come along. Maybe this list will encourage someone to join what I understand to be the world's best conference for APEX developers.
The APEX topics listed in full herehttp://kscope15.com/component/seminar/seminarslist?Itemid=57&topicsid=2
The links below go directly to the (more...)
I'm sure we've all done it at some point or another, used some "feature" in the database you're probably not meant to.
Interactive reports still have a few misgivings prior to APEX 5 so some tried to utilise gReport object, since it was available in the generated page but undocumented - which in Oracle speak means that they're more than entitled to change behaviour in future without telling or supporting you.
I understand htmldb_Get put (more...)
Hard to believe that the 2nd Annual World Wide Data Vault Consortium (WWDVC15) is NEXT WEEK in beautiful Stowe Vermont. It promises to be an excellent event. The speakers include myself, Claudia Imhoff, Dan Linstedt (the inventor of Data Vault), Scott Ambler, Roelant Vos, Dirk Lerner and many more. The focus will be DV 2.0, […]
I’ve never really spent time on evolution because most of the time I use baselines for emergency sql plan management and not with the added value of controlled evolution with which the feature was conceived.
But some observations on sql plan baseline evolution originating from the questions:
- What does evolution actually do?
- What information does it use?
- What happens with DML?
Starting point – one baselined plan
1. FTS plan in memory from SQL which (more...)
Student questions are always interesting! They get me to think and to write. The question this time is: “How do I write a Bash Shell script to process multiple MySQL script files?” This post builds the following model (courtesy of Download MySQL Workbench) by using a bash shell script and MySQL script files, but there’s a disclaimer on this post. It shows both insecure and secure approaches and you should avoid the insecure (more...)
Fedora comes with
gedit installed but the
gedit installation is bare bones. You can update
gedit to include supplemental Plug-ins with the following
yum command as the
yum install -y gedit-plugins
It generates the following log file:
Loaded plugins: langpacks, refresh-packagekit
mysql-connectors-community | 2.5 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql56-community | 2.5 kB 00:00
pgdg93 | 3.6 kB 00:00
updates/20/x86_64/metalink | 14 kB 00:00
Attention Perth Oracle technologists.
I'll be giving a dry run of my Kscope talk
to the user group in Perth on May 28th, which happens to be the deadline for us to submit copies of our sessions to ODTUG.
So if you're in Perth, have any form of interest in APEX - come by the Oracle offices in near Kings Park by 8am, or come a bit earlier for a feed.Evidence-Based APEX: Building Better Practices
- When is Forms 12c coming out?
- Is Forms dead?
- Will Forms ever run without a Java applet?
- Will we be able to run Forms on Chrome?
- How can I deploy my form to mobile devices?
The list of pressing questions about Oracle Forms seems endless, but we will finally get you some answers!
ODTUG and the Oracle Forms community have coordinated a free Q&A webinar hosted by Michael Ferrante, the Oracle Forms project manager himself. He (more...)