TweetShareSharePin0 SharesIn this post I’ll finish up the CRUD implementation using records, procedures and views. This series of blog posts started with this post which was followed by this. At this point we have a working report that links to a form. The report is based on a view and the form is based on a procedure. At this point the form is only loading the record in using a procedure that uses a record in its signature. In this post […]
Oracle
SQL Access to the alert-log in 11g and an oddity
TweetShareSharePin0 SharesQuite a while ago I wrote about how to setup the alert log as an external table. Since then 11g has been introduced and is now widely used. It of course changes the location and makes the alert log an xml file. While it is possible to select from it using xml functions like Laurent Schneider does here, it is still a bit cumbersome. Tanel Poder (@TanelPoder) found a nicer way by using X$DBGALERTEXT which does a really nice job […]
OOW 2010 Develop Keynote
TweetShareSharePin0 SharesYes, this post is a little out of order as it clearly didn’t take place after the Thursday afternoon sessions. I missed it during the conference so I had to catch up on it later on the on demand site. I thought it was interesting enough to write up a few notes. It was held by Tom Kyte and the subject was “What’s new in database development”. It’d be more correct to say Oracle development than database development as […]
OOW 2010 Thursday Afternoon
TweetShareSharePin0 SharesFor the afternoon I had two sessions I attended. The first was “Quantifying Oracle Performance” and the second was “The X-files – Managing exadata and highly available databases”. I anticipated both to be great and possible be among my favorites for the week. Unfortunately neither met my expectation, so this is going to be a fairly short post. The first one was “Quantifying Oracle Performance” with Craig Shallahamer, I have seen many presentations with Craig and he has always been […]
OOW 2010 Thursday Morning
TweetShareSharePin0 SharesThe day starts with a presentation b6 Tom Kyte about “What else can you do with system and session data”. Tom starts with reviewing the history of tuning an Oracle database. The prehistoric era (v5) required writeing debug code as that was the only way to get any information about what the code did. The dark ages followed (v6) and now Oracle introduces: Counters/ratios bstat/estat SQL Trace The first few (7?) v$-views are introduced In the renaissance era (v7) […]
OOW 2010 Wednesday Morning
TweetShareSharePin0 SharesWednesday starts off with a presentation about a new feature in APEX 4.0 that I have not had a chance to look into. It is how you use and develop plugins. The presentation was held by Patrick Wolf who is also the developer of the plugin feature. Scott began by showing how a plugin is used (that is using a plugin compared to developing it). You install a plugin by selecting plugins in the shared components section, and then it […]
OOW 2010 Monday Afternoon
TweetShareSharePin0 SharesThe afternoon was kicked off with a presentation on using APEX in large projects by Dimitri Gielis. These re my notes for what Dimitri told us. Many people feels that APEX cannot be used for anything larger than a singe developers app. Sumneva uses EC2 for both demo and development work with their clients. They have readymade scripts to create new projects that sets up filesystem directories, APEX application, and subversion. They’re finding that the agile project methodology works […]
OOW 2010 Monday Morning
TweetShareSharePin0 SharesThis will be a APEX only day. The day starts with two APEX 4.0 presentations. First up was a presentations about dynamic actions in APEX held by Anthony Raynor. Dynamic acttions is a declarative way (in 4.0) to use javascript to enhance clientside behavior of an APEX application. It is used for things such as disabling some fields on the page in some situations. Using it is done by defining four things: When Condition Action Affected elements For example […]
Two good posts that are related
TweetShareSharePin0 SharesI like when a blog I follow links to a blogpost I have already seen and that I thought was a gem. I used to happen quite frequently when Cathy Sierras blog was active, but it still happens. The reason it is nice is that I like it is that if the first post was really good, you can almost guarantee that I will like the next writer I follow that discusses the same thing. This week it was […]
Apex 4.0 moves to apex.oracle.com
TweetShareSharePin0 SharesIn case you haven’t noticed already, David Peake’s blog just announced that APEX 4.0 moves one step closer to become available for download. It is now the release that powers apex.oracle.com. http://dpeake.blogspot.com/2010/06/apex-40-comes-to-httpapexoraclecom.html This is good news as it shows that the release is getting close to be completed. Upgrading apex.oracle.com is usually one of the last public steps before a release becomes available to download. TweetShareSharePin0 Shares