Blog PostsStatistics Feedback About Login  


Go

Blog Selection


Oracle Application Express 3.2: The Essentials and More: A review (or Things I've learned from TV)
4
David Njoku 19-JUL-2010 09:26

I have a nephew who is 10. Just the other day he was asking me about ancient Rome and I was halfway through a long description of the lives of gladiators before I realised that all the 'facts' I was giving him had come straight from the TV show, Spartacus: Blood and Sand and not from a history book at all.

I realised, with shame, that almost everything I think I know comes from television. Ask me about psychology and I've got Lie to Me; ask me about forensic science and I've got CSI; ask me about the inner thoughts of women and I've got Sex and the City; ask me about Oracle Apex...

A couple weeks ago the good people at Packt Publishers kindly sent me a copy of the newest Apex book on the market, Oracle Application Express 3.2: The Essentials and More by Arie Geller and Matthew Lyon to review.

Here's what I think:

Don't write an expiry date into your name (or what I learned from Space 1999):
There's an elephant in the room; let's ignore it no longer. It is the most unfortunate coincidence of timing that this book on Apex 3.2 has come out the same week we've all been going crazy about Apex 4. Definitely embarrassing. But does this mean that the book, like Benjamin Button, is born already old and out-of-date? In some ways the answer, unfortunately, is yes; but until the market is flooded with Apex 4 books you should not let that put you off this book. The core of Apex remains unchanged, and this book covers that admirably.

Sequence does not matter (or what I learned from Quantum Leap)
I must admit that I had a serious issue with the sequence in which the authors chose to order their topics. I completely understand their thinking, but when I buy an Apex book I do not want to spend the first 40 pages reading about DOM objects, javascript, CSS and html before the first real mention of Apex, and another 40 pages before I get my first real look at the IDE!

However, I understand that technical books are not necessarily meant to be read sequentially. If you buy this book feel free to skip straight to page 79; you can return to the earlier pages later. And you should, because a lot of it is actually informative (I, personally, needed to read the section on shortcuts on page 63).

People talk about what they know (or what I learned from House)
"If you go to an oncologist with a headache," Dr House says in one episode, "he'll diagnose cancer; but take that same headache to an optician and he'll recommend new glasses."

This book is full of references to right-to-left languages and Apex's globalisation abilities. I'm guessing this is something one or both of the authors are interested in. If this is functionality that you require then you really must buy this book.

The story is in the details (or what I learned from The Wire)
Reading this book I made a list of subjects I felt the authors covered very well, and of those capabilities of Apex that I - not a newbie in Apex but far from an expert - was discovering for the first time. And I'm pleased to report that this list was much longer than I expected it to be. From whole chapters like the very useful section on Best Practices (Chapter 24: a must-read for any newbie) and the chapter on Deployment (Chapter 20), to little things using $v in Apex Ajax instead of $x(itemName).value.

There's more. Their work on the APEX_ITEM api was exhaustive (I did not know about APEX_ITEM.MD5_CHECKSUM). And, as an Oracle Forms developer, I was very interested in Chapter 23, which is about migrating applications from Forms. I got the impression that this was not necessarily something that interested the authors as much as it interested me, but it is good to find a book that covers the subject.

Nothing's perfect (or what I learned from Lost)
The chapter on migration wasn't the only time I felt that perhaps the authors were bored with a particular aspect of their subject. The whole section on the Apex IDE was often merely descriptive rather than explanatory.

In addition, I understand that they needed to include a section on the Apex SQL Workshop for completeness, but if you're an Oracle developer and you don't use TOAD, PL/SQL Developer, SQL Developer or even SQL*Plus then you really shouldn't be over here playing with the big kids. Apologise to the rest of the class and then leave the room immediately.

Conclusion
As I said earlier we cannot ignore the fact that Apex 4 casts its wide shadow over this book. Only you can decide how important a factor this is to you. Outside of that fact, this is quite a good book: if you are a newbie it will not get you started on its own - for that you will need the Internet's resources (start here: apex.oracle.com) - however, the authors' approach to Apex is often quite theoritical (and not just brutishly practical as many technical books can be) and this will furnish you with the background information you will need if you wish to do more than merely dabble with this technology.

If you are an experienced Apex developer the answer to the question "should I buy this book?" depends largely on your attitude to technical books. Personally, I like them. Google has pretty much killed off technical reference books, but I think there is still room for books like this that give you more information than a cursory web search can.

I'd love to tell you more, but I've got to go watch Jerry Springer. My nephew might have some questions about the life of the average, normal American.

Show Comments (0)

Video - JavaScript for PL/SQL Developers
4
Dan Mcghan 19-JUL-2010 08:09

While at ODTUG this year, I had the pleasure of presenting three different times. The one presentation I did on my own was “JavaScript in APEX – A Lesson for the PL/SQL Developer”. The presentation was inspired by my experiences learning the language and later teaching it to others with similar backgrounds.

I almost called the presentation “JavaScript, the Lost Lesson” because that seems to be the reality for so many APEX developers. When you come from the database world, JavaScript can seem so awkward and difficult. Believe it or not, it’s not that bad! In fact, as a database developer, you are already have a good grasp on some of the most important concepts – you just don’t know it yet... Have a look at the abstract, and if you are interested, watch the recording.

Abstract

Oracle Application Express developers often have strong backgrounds in SQL and PL/SQL, but JavaScript is another story. However, JavaScript is a very important part of any well-built Web 2.0 application. In this session, explore JavaScript through a series of analogies, 9 in total, that will relate important concepts in the language back to what you already know in the database world.

Video

Click here to view this video, along with various other recordings, at SkillBuilders.com.

Look for JavaScript in APEX – A Lesson for the PL/SQL Developer.


Show Comments (0)

APEX4 Password Strength Meter Item Plugin
4
Paulo Vale 16-JUL-2010 15:56

I was doing some tests with the new plugin functionality coming with APEX4 and the result is this plugin I'm sharing with you today.I based the plugin on the "Ajax Password Strength Meter Script" that you can find following this link: http://simplythebest.net/scripts/ajax/ajax_password_strength.htmlIt's a small plugin using jQuery that provides an easy interactive way to show the strength of a



Show Comments (0)

ChangeCase: A Simple Apex 4.0 Plugin
4
Andy Tulley 16-JUL-2010 15:24

Creating a simple Apex 4 Item Plugin to allow the contents of a Text Field to be automatically uppercased or lowercased.]]>
Show Comments (0)

Quick Notes
4
Håvard Kristiansen 16-JUL-2010 12:42

Just a bit of housekeeping.

APEX 4.0 Builder Hotkeys
This is just a quick note on the APEX 4.0 Builder Hotkeys. I have updated the script because not all previous/next buttons were included in the last version. Alt + PageUp/PageDown should now give the right response.

You can download and install the script here: http://userscripts.org/scripts/show/81058

Installation instructions can be found here: http://monkeyonoracle.blogspot.com/2010/07/apex-40-builder-hotkeys.html

Ye Olde Sample App
...is still working! I just went through the Application Upgrade and changed the theme while at it. I even updated the Google Maps example. ("Updated" sound so much better than "fixed a bug". Quick solutions will make you do that...) This application will probably not be updated anytime soon. There are a few more elaborate examples I had in mind, but then there is this "time"-thing all over again. Exploring APEX 4.0 is at the top of my spare time roster for now.

The application will be left alone for the time being, and can be found here: http://apex.oracle.com/pls/apex/f?p=28990:1

Summer Vacation
Finally, my last day of work before I start my summer vacation. One of the nicer benefits as a worker in Norway, is the length of paid vacation established by national law. I guess this is not so normal for Americans.

True story from the ODTUG Kaleidoscope this year. An American guy comes up to me with his friend, and after introductions the following conversation takes place:
Him: So, you're from Norway?
Me: Yep!
Him: Could you tell my colleague here how much paid vacation you guys have?
Me: Five weeks!
Friend: ... (going through the whole stunned jaw dropping improvised look)

Cheers :-)
Show Comments (0)

APEX 4.0 Known Issues
4
David Peake 16-JUL-2010 12:06

Since releasing APEX 4.0 we have identified a number of issues.
Many are directly related to upgrading applications from previous releases.
The known issues are outlined on OTN here: http://www.oracle.com/technology/products/database/application_express/html/4.0_known_issues.html
As with any upgrade we strongly recommend you test your applications in a development environment before applying to production.

Our development team is working very hard on these issues.
Many issues have workarounds provided.
Where appropriate we are also releasing patch set exceptions which can be downloaded from Oracle Support and installed in your environment.

We intend to roll all of these fixes into an APEX 4.0.1 release.
Before you ask - I can't provide dates for APEX 4.0.1 release!

Regards,
David
Show Comments (0)

*Updated* Apex jQuery spinbox v1.0 [plugin]
4
Rutger de Ruiter 16-JUL-2010 11:02

After a review of Patrick Wolf, a few changes are incorporated to make this plugin a 1.0 version. As I said before, my first try was really simple (hence the 0.1), and Patrick took the time to review and change/add some of the code of the plugin. The following things have changed:

* Minimum value is required
* New number alignment attribute
* Autocomplete for text field is turned off
* New validation code that:

1. Checks if the value is numeric
2. Checks if the value is in range of min/max
3. Returns validation messages

* Renamed the library files according to apex jQuery namespace
* Added source files in release
* Added server ready files in case of webserver install
* Added a readme file
* Added installation and de-installation steps in the readme file

You can still find the demo on this location.
The download is stille hosted here.

And again, thanks to Patrick for the help!
Now go on, have fun with this plugin!
Show Comments (0)

New Plug-in in the Wild! SkillBuilders Save Before Exit
4
Dan Mcghan 16-JUL-2010 07:54

Back in 2008, I blogged about how alert users to save their work before leaving a page. Although that was some time ago, the article is still popular to this day. Even while presenting at Kaleidoscope a couple weeks ago, someone asked if we would be creating a plug-in to make this functionality easier… While uncertain at the time, the answer is pretty clear now: Why yes, yes we will ;)

Click here to view/download the plug-in!

Description

Have you ever filled out a form and accidently left the page without saving your work? It is actually quite easy to do. Thankfully, browsers have features to help prevent this from happening. The problem, however, is that taking advantage of those features can be quite difficult - until now.

The SkillBuilders Save Before Exit dynamic action plug-in allows you to notify your users if they leave a page without saving their work. Simply install the plug-in and add it to your page!

Features at a glance

  1. Activates when a user makes a change to an item on the page.
  2. Warning message displayed if user tries to leave page without clicking a button. Includes: Closing the browser, clicking the back button, clicking a link, etc.

Show Comments (0)

APEX 4.0 pierwsze Bug-i
4
Apex dbe pl 15-JUL-2010 22:24

Tak tak, juz zebrała się lista wyłapanych bug-ów dla APEX-a 4.0. Lista dostępna jest tutaj i ciagle się rozszerza.


Nieskromnie się pochwalę, że wpis nr 9864659 jest moim dziełem :) Nie ma jakieś specjalnej procedury zgłaszania bug-ów, po prostu ludzie z Oracle-a nasłuchują Forum i po cichu sprawdzają czy jest to bug czy nie. Miałem problem z Mapami więc zacząłem wątek, wątek został podjęty przez człowieka, który nie awiszował się, że jest z Oracle. Ostatecznie na końcu powiedział, że mam rację i zostało to zapisane jako błąd numer XXXX. A całą historię wpisu można przeglądnąć sobie tutaj.

Przy okazji zapowiem zbliżające się dużymi krokami nasze Polskie Forum. Już niedługo myślę, że najpóźniej w przyszłym tygodniu odpalimy Polskie Forum APEX. Silnik już zmajstrowaliśmy jeszcze musimy podnieść wersję APEX-a na naszym serwerze do 4.0 (bo w takiej wersji już robiliśmy forum) i będzie GoLive.

Show Comments (0)

Recursive Subquery Factoring
4
Scott Wesley 15-JUL-2010 17:17

OK, this post is partially for my benefit because I'm sure in future I'll need to re-think how this works - and I'll want the basic syntax on hand.

From 11g Release 2, the SQL WITH clause has been extended to allow recursive queries. This new syntax complies with the ANSI standards, as opposed to Oracle's CONNECT BY, START WITH keywords.

Unfortunately in this simple example, the ANSI syntax is somewhat more verbose. I wonder if this evens out as the complexity of the query increases, or if the readability of the code is "scalable"?
-- 10g method
SELECT o.org_id, o.name, o.parent_org_id, level
FROM organisations o
CONNECT BY PRIOR org_id = parent_org_id
START WITH org_id = 1000;

-- 11 method
WITH org_sage (org_id, name, parent_org_id, reportlevel) AS
  (SELECT org_id, name, parent_org_id, 1 reportlevel
   FROM   organisations
   WHERE  org_id = 1000
   UNION ALL
   SELECT o.org_id, o.name, o.parent_org_id, reportlevel+1
   FROM  org_sage p, organisations o
   WHERE p.org_id = o.parent_org_id
)
SELECT org_id, name, parent_org_id, reportlevel
FROM org_sage;
Another unfortunate outcome is a quick test of throughput - 10000 iterations on my laptop gave the following respective timings.
.81 secs
.000081 secs per iteration
3.56 secs
.000356 secs per iteration
So it might be best to compare the two in your scenario/data, and consider the value of using the ANSI format in your case.

Further documentation can be found here, in the SQL Language Reference, under the SELECT statement.

Remember, the key to understanding recursion is understanding recursion :-)
Show Comments (0)

 1 2 3 4 5 6 7 8 9 10 








 
 
Blog Roll
  • APEXtras
  • Ahcene Bourouis
  • Andy Tulley
  • Anja Hildebrandt
  • Anthony Rayner
  • Anton Nielsen
  • Apex Blog
  • Apex dbe pl
  • Ben Burrell (Munky)
  • Bernard Fischer-Wasels
  • Bradley Brown
  • Carl Backstrom
  • Carsten Cerny
  • Carston Czarski
  • Christian Rokitta
  • Christopher Beck
  • Dan Durbaca
  • Dan Mcghan
  • David Njoku
  • David Peake
  • Denes Kubicek
  • Dietmar Aust
  • Dimitri Gielis
  • Dirk McComsey
  • Doug Gault
  • Douwe Pieter van den Bos
  • Duncan Mein
  • E-Dba
  • Eric Boissonneault
  • Evgeny Timoshinin
  • German APEX Community
  • Håvard Kristiansen
  • IAdvise
  • Ilmar Kerm
  • Iloon Ellen
  • Insum
  • Jason Aughenbaugh
  • Jason M.
  • Jason Straub
  • Jean-Phillipe Pinte
  • Jeff Holoman
  • Jeffrey Kemp
  • Joel Kallman
  • John Scott
  • Jon Trostheim
  • Jornica
  • João Oliveira
  • Kristian Jones
  • Learco Brizzi
  • Louis-Guillaume Carrier-Bédard
  • Marc Sewtz
  • Mark Lancaster
  • Martin B. Nielsen
  • Martin Giffy D'Souza
  • Matt Ball
  • Matt Nolan
  • Niels de Bruijn
  • Niels de Bruijn
  • Noel Portugal
  • Oracle Nerd
  • Oracle Quirks
  • Oradude
  • PL/GMaps
  • Patrick Wolf
  • Paul Brookes
  • Paulo Vale
  • Pawel Barut
  • Peter De Boer
  • Peter Manchev
  • Peter Raganitsch
  • Przemek Staniszewski
  • RCI
  • Roel Hartman
  • Rutger de Ruiter
  • Sara Blair
  • Sathish Kumar
  • Scott Spendolini
  • Scott Wesley
  • Stew Stryker
  • Sujay Dutta
  • Sumnertech Blog
  • Tobias Arnhold
  • Tyler Muth
  • Unknown APEX
  • Wei Zheng

    © Created and Hosted by Apex Evangelists