Recently we came across a question from the field about how an Excel spreadsheet can be loaded into an Oracle table with the help of OWB 11GR2. There are many ways that this can be achieved. With OWB 11GR2, the introduction of Code Template adds a new way of how a spreadsheet can be loaded. [...]
Recently we came across a question from the field about how an Excel spreadsheet can be loaded into an Oracle table with the help of OWB 11GR2. There are many ways that this can be achieved. With OWB 11GR2, the introduction of Code Template adds a new way of how a spreadsheet can be loaded. [...]
Customers can increase developer productivity and simplify application development cycles using Oracle SQL Developer 2.1 – the latest release of the popular development and migration tool that comes with every Oracle Database. This latest release introduces two new key capabilities – PL/SQL Unit Testing and Data Modeler Viewer – in addition to a slew [...]
In the last post I illustrated the problems you can run into when you rely on Oracle to aggregate statistics on partitions or subpartitions to generate estimated Global Statistics at higher levels of the table. Until there are statistics for all of the relevant structures then aggregation won’t take place so, for example, if you [...]
On the weekend of May 22, 2010, the Portland Development community is coming together in a way never experienced before.
Using the University of Portland campus, SQLSaturday, Portland Code Camp, and Portland Bar Camp are combining and coordinating efforts to bring 800-1000 regional technology professionals together for the opportunity to immerse themselves in seminars, presentations, group [...]
Use Oracle Virtual Private Database and Function Result Cache—securely.
Link to the original site
Ruby enthusiast and friend of the ‘Lab Raimonds Simanovskis (@rsim) just released a maintenance update to his ActiveRecord oracle-enhanced-adapter, bringing it to version 1.2.4.
This will be the final version of the adapter for Rails 2, after which he’ll move it to Rails 3.
Last month, he updated ruby-plsql.
As you know, we’re big fans of Ruby in [...]
In the last part, I asked you to trust me that true Global Stats are a good thing so in this post I hope to show you why they are, to make sure you don’t kid yourself that you can avoid them. (Updated later – this is all on 10.2.0.4)
Why would you even want to [...]
I just posted the latest version of logger, my PL/SQL logging utility to https://logger.samplecode.oracle.com/. There are a number of new features as well as bug fixes, many of which were suggested by other people in the comments of my previous blog post on logger. You can view the new features and fixes in the “Change [...]
I’ve been gradually building out a logging utility for PL/SQL over the last year or so. It’s been a huge help on some complicated projects, especially in APEX Applications with a lot of AJAX. I’m sure most people reading this have been stuck on a problem, created a logging table, and sprinkled a [...]