In our previous blog posts, we had covered the scenarios of using multiple exceptions and using NO_DATA_FOUND exception when used with bulk collection. In this blog post, we will cover the basic exception handling scenarios.
Other News
Oracle BI EE 10.1.3.3/2 – Sorting of Reports in Dashboards
(Venkatakrishnan J) I just picked up an old unanswered question in the forums to blog about today. The question is “How do we enable sorting of reports within Dashboards”?. We will see two ways of achieving this. One approach will enable sorting on a report to report basis. The other approach will m
The DBA’s Toolbox, Part 2
(Buck Woody) In the last installment of this two-part series, I mentioned that there are often more things to learn about SQL Server Management than you can take in at one time. A simple method to help cut the information down to size is to categorize it all into concepts, processes and tools. You c
RS HowTo : Pass a multivalue parameter to a query using IN
(Simon Sabin) One of the most common requests I’ve seen when people write queries for applications is to be able to pass a delimited list of values and use it in an IN clause.
Single-click script execution on multiple SQL Servers
(Helen Joyce) An ingeniously simple tool to speed up the common task of running lots of scripts across lots of databases, SQL Multi Script is just the helping hand a busy DBA needs.
Editorial Thoughts for Today
Webcast Tomorrow: Understanding Indexes and Index Fragmentation In this webcast, we’ll examine how to look at your indexes, how to understand them and how to apply them. We’ll look into fragmentation and how you can determine whether an index needs to be rebuilt. We’ll look at the options you have available to you for maintaining your indexes as well. > […]
Writing Reliable .NET Code
(Alessandro Catorcini and Brian Grunkemeyer) When we talk about something being reliable, we’re referring to it being dependable and predictable. When it comes to software, however, there are other key attributes that must also be present for the code to be considered reliable.
Building Mashup-Friendly Sites in Rails
(Jack Herrington) Your web services interface, be it in whatever format—XML/RPC, SOAP, even JSON—is not mashup friendly. Let me ask you a question, what is the gold standard of mashupable widgets? For many that would have to be Google Maps, arguably the first truly mashupable widget that really took
At your shop, who is responsible for the SQL performance?
(Willie Favero) This morning I was chatting via SameTime with Pat Bossman (IBM DB2 Optimizer Team) about EXPLAIN and Visual Explain. Somehow we started to discuss who is actually responsible for the performance of the SQL developed for an application program. Pat commented “What a good question for
Simplified Business Rules Engine
(Jonathan) So I was thinking about some of my ideas that I had already previously written in my blog and I was also doing research on some things. Considering that I only recently started database developing, there are some things that I have some slight understanding in. There are also things that