First we see the facelift in the Open-Dialog. It's now the typical Windows-Dialog, where you have much more flexibility.
New features in the Convert-Dialog:
- New Feature "Converting to and from XML"
- Checkbox "Overwrite"
- Checkbox "Keep window open", if you have to convert many files at once.
Preferences-Dialog, Tab "General":
- The checkbox "Hide PL/SQL Compile Dialog" is new
- Web Browser location (Forms 11g: (more...)
I downloaded sqldeveloper-126.96.36.199.64-x64.zip, unzipped it, and placed it under c:program filessqldeveloper-188.8.131.52.64-x64. I double-clicked the main sqldeveloper executable and expected it to "just work" (as it usually does), but this time it didn't.
I got the following error message:
sqldeveloper64W.exe - System Error
As I have been preaching from my soapbox for years now, Oracle Forms will remain a constant, supported development tool to build on premise, enterprise level, data entry desktop applications. However this time, Oracle has joined me by declaring their commitment to Oracle Forms, as Oracle Forms 12c was released on the heels of OOW. Oracle Forms 12c can be downloaded here. Our customers and team have been anticipating Oracle Forms 12c, and it is great to finally have it available.
Just a quick note that (as mentioned by Christian Neumueller earlier) Apex 5 now populates an Application Context
APEX$SESSION with the session’s User, Session ID and Workspace ID:
SYS_CONTEXT('APEX$SESSION','APP_USER') SYS_CONTEXT('APEX$SESSION','APP_SESSION') SYS_CONTEXT('APEX$SESSION','WORKSPACE_ID')
Using the above should be faster in your queries than calling v() to get these values. Note that the alias
'SESSION' won’t work like it does with v().
The context is managed by the database package
APEX_050000.WWV_FLOW_SESSION_CONTEXT which is an undocumented (more...)
For the developer the most significant change in the Page Designer is the component view. This will be a tab in the center pane instead of a completely separate page.
Most time was spent showing the new Interactive Grid. The Interactive Grid will be a, loosly (more...)
defaults.xml gets created in the folder you specify. It looks like this:
You have a Select List item on your page driven from a dynamic query, e.g. one that only shows valid values. One day, users notice that the list appears empty and raise a defect note.
You check the query behind the list and verify that indeed, the list should be empty because there are no valid values to show. It’s an optional item so the user is free to save the record if they (more...)
Snappy title, huh?
Aka: Why a sql plan baseline may be no guarantee of stability.
The other day, a problematic plan flip…
Cue much discussion about plan flips etc.
My thoughts on stability are that the priority for most application owners is stability and predictability but that does not tally with the defaul CBO behaviour and potentially you have to turn off a helluva lot to even get close.
I have (more...)
Plan degradations on upgrade are normal.
This one’s no different.
On further investigation, turned out application was setting optimizer_mode = first_rows somewhere.
First point about this is that first_rows really shouldn’t be used either as a hint or as an optimizer_mode.
What does FIRST_ROWS mean?
From 11g doco:
The optimizer uses a mix of costs and heuristics to find a best plan for fast delivery of the first few rows.
If any sort of (more...)
At last night's WWCode Cincinnati panel, I recommended that developers talk to their DBA about what advanced capabilities their RDBMS can offer, so that they don't end up reimplementing functionality in the app that are already available (better and more efficiently) in the database itself. Devs can waste a lot of effort by thinking of databases as dumb, inert data boxes.
I was asked an excellent question: "Where can a dev quickly familiarize herself with (more...)
Quite a long time ago I made a collection of MP3s available from our Apex website and made them playable within the browser using Google’s shockwave player, using code like this:
<embed type="application/x-shockwave-flash" flashvars="audioUrl=#FILE_URL#" src="/3523697345-audio-player.swf" width="400" height="27" quality="best"> </embed>
This relies on the user’s browser being able to run flash applications. It looked like this:
With HTML5, however, this is no longer required, so I’ve updated it to:
<audio controls preload> <source src="#FILE_URL#" type="audio/mpeg"> (more...)
Last week was Oracle OpenWorld in San Francisco, California, and a huge week for me and our whole team at AuraPlayer. Our week began on Sunday when I presented my “Mobile / Cloud Buzz Words for Dummies” to over 120 people eager learn how to start their mobile journey. But in fact they weren’t! I was shocked to find out, by a show of hands, that only 3 people in a room of over (more...)
Stefano Illustrates how to integrate your existing repository in GitHub with Oracle Developer Cloud Service using you're preferred Git client or IDE that supports Git integration. Check out Stefano's entry here.
Let me show you with a picture:
To add this to your page, simply change the page template to "Right Side Column", and note that a "Right Column" template position appears in the (more...)