Once again the ADF PMs have been hard at work to provide us all with great training content. This time in the form of a full online course.
Oracle University has begun the First Global Teach of the Oracle Middleware 12c: Build Rich Client Applications with ADF course online.
This course covers all the useful features of ADF Business Components including how to build and test reusable business services. After creating the application they drill (more...)
A recent addition to my Oracle PL/SQL library is the book Oracle PL/SQL Performance Tuning Tips & Techniques by Michael Rosenblum and Dr. Paul Dorsey.
I agree with Steven Feuerstein’s review that “if you write PL/SQL or are responsible for tuning the PL/SQL code written by someone else, this book will give you a broader, deeper set of tools with which to achieve PL/SQL success”.
In the foreword of the book, Bryn Llewellyn writes:
Gartner has just released another iteration of their classic “Hype Cycles.” They are up to more than 100 different topics now, but one interesting graph is one is the one for Emerging Technologies.
Source: Gartner Hype Cycle for Emerging Technologies 2014
I want to comment on a couple of points from this graph:
- Internet of Things as peaking – completely agree. Everybody is talking about it but what do we have? An internet-connected smoke alarm.
- Big (more...)
I’m not in favour of calling books a “must-read”, but if you want to get your own book commercially published, I have to say you must read Write the Perfect Book Proposal: 10 That Sold and Why, 2nd Edition.
The main force of this book is that it explains the publishing industry from the inside: What a publisher is looking for. The authors honestly explain what the publisher will and will not do, and that (more...)
I’ll be going to the UKOUG Tech 14 conference in Liverpool in December to give one of my favorite presentations: “APEX or ADF? From Requirements to Tool Choice”. I’m also leading the Development Tools roundtable, which is always lively at the UKOUG conference. If you want to discuss your options as a developer in the Oracle world, UKOUG Tech 14 is the place to be.
APEX or ADF? From Requirements to Tool Choice
You want a checkbox item on a page which is a preference, you want it to be remembered for the user across login sessions, but you don’t want the overhead of storing it in a database table. You might choose to store the value in a cookie instead. It may be lost (e.g. when the user clears their cookies or changes to a different browser or another computer), but we don’t mind – it’s just a preference.
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
Ever exported a whole schema containing DBMS_SCHEDULER jobs with non-default job classes?
Chances are that you hit the following error message when you attempt to import the dump later on.
ORA-39083: Object type PROCOBJ failed to create with error:
God or Larry knows why Oracle feels the compelling need of changing some of its page links over time.
Oracle Application Express' main page URL is now:
May be I am a bit slow in picking up these changes, I don't really know if this
Quick, how many different Web Service specifications are there?
- less than 20
- between 20 and 40
- more than 40
I was in doubt whether the answer would be 1) or 2) – after all, there is a lot of WS-* stuff. Turns out the answer is 3) – there are currently 50 web service specifications.
A technology with 50 specifications is unlearnable. The basics of web services is simple and useful, but the IT industry (more...)
You say you want to present and share your knowledge with the world (or at least your little corner of the world)… Your boss says there is no $$$ to pay for any technical conferences… You want to be a rock star and have adoring fans “LIKE” your blog or web site… Have I got […]
I was recently advising a transition project where a customer was switching support and maintenance supplier. This means that one organization must take over a system that has been maintained by another organization for a number of years.
A lot of information is lost in these transitions because knowledge of the problem domain has been accumulated in the heads of developers over many years. This loss cannot realistically be mitigated.
But sometimes, specific information about (more...)
The UTL_FILE database package is used to read from and write to operating system directories and files. By default, PUBLIC is granted execute permission on UTL_FILE. Therefore, any database account may read from and write to files in the directories specified in the UTL_FILE_DIR database initialization parameter [...] Security considerations with UTL_FILE can be mitigated by removing all directories from UTL_FILE_DIR and using the Directory functionality instead.
© Eddie Awad's Blog, (more...)
I’m currently estimating the effort for a piece of software. With 20 years of experience under my belt, I don’t find estimating hard any longer. But back when I started out, I was terrified whenever I was asked to provide an estimate.
In most organizations, too much of the estimating is art and too little is science. Experienced developers can produce good, realistic estimates, but these are often treated as individual efforts and no organizational (more...)
I was aware that up to Oracle 11g, a PL/SQL program wasn’t allowed use an associative array in a SQL statement. This is what happens when I try to do it.
SQL> drop table test_array purge;
SQL> create table test_array as
2 select level num_col from dual
3 connect by level <= 10;
SQL> select * from test_array;
Steven Feuerstein was dismayed when he found in a PL/SQL procedure a cursor FOR loop that contained an INSERT and an UPDATE statements.
That is a classic anti-pattern, a general pattern of coding that should be avoided. It should be avoided because the inserts and updates are changing the tables on a row-by-row basis, which maximizes the number of context switches (between SQL and PL/SQL) and consequently greatly slows the performance of the code. Fortunately, (more...)
Today the official program is online for DOAG conference 2014 in Nuremberg. My presentation is confirmed “The Dirty Dozen – ADF Migration to 12c in the IKB”.
I will speak over our experiences with following
- provide user software
- install servers
- iterative test migrations
- migration plannig
- real migration
- and the problems and pitfall’s we find on our way
If you speak german and you are interested in some of this, you should come and attend my (more...)