TweetShareSharePin0 SharesThat was essentially reader Gabriel posted on my post Suppressing repeating values in SQL. At first my reaction was just to ignore it as I felt it was too odd. But then use FarMan posted a complete opposite “Dude, you just saved my life. Thanks so much!”. Could the same post really get so different reactions? Gabriel’s question was:“The above is a neat trick, but only for the purpose of showing off. What’s the use? Please enlighten me, because […]
Author: Mathias
The power of using records in APEX
TweetShareSharePin0 SharesDo you use forms based on procedures in APEX? If not, why not?Do you use records in the procedures you use for forms in APEX? If not, why not? I like procedures and records and with APEX I like them even more. Why you say? Should you not just point forms against tables and let the APEX magic take care of it all? No, I do not think you should. The reason is that I love that feature for […]
Suppressing repeating values in SQL
TweetShareSharePin0 SharesSometimes you my find a need to suppress repeating values in SQL. One case is when your reporting tool does not have such a feature or you just cannot find it fast enough. That happened to me with a report that was to be converted to APEX from Oracle Reports the other week. I could not find an option in APEX to suppress repeating values, and I did not want to make them all control breaks as that would […]
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 […]
Oracle VirtualBox and Developer Days Appliance
TweetShareSharePin0 SharesAt the start of the Christmas break I decided to get started with Oracle VirtualBox 4.0. To get up and going faster with an 11g database I opted to download the pre-made image (called appliance by Oracle) that they use during Developer Days. It has a lot of things pre installed and ready to go. Oracle Enterprise Linux 5 Oracle Database 11g Release 2 Enterprise Edition Oracle TimesTen In-Memory Database Cache Oracle XML DB Oracle SQL Developer Oracle SQL Developer Data Modeler Oracle Application […]
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 Afternoon
TweetShareSharePin0 SharesThe afternoon started off with a presentation on the result cache in 11G. It was held by Rob van Wijk. DB result cache is a cache for the resultset of a query or a plsql block. If the same query is executed again with the same parameters, then the code is not executed, the same resultset is sent back. There are two parameters that controls the result cache. result_cache_size_max_size result_cache_size_max_result Size is the size of the cache in bytes […]
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 […]