John details the benefits of the upcoming Online Conference for Developers. This event is a NO-COST, online conference you can attend from the comfort and convenience of your home, desk or office. That means no flights, no hotels, no crowds - and best of all, no expense!

The PL/SQL Standards page of PL/SQL Obsession now offers a third choice for pre-defined standards for PL/SQL development.

 

This document has been fine-tuned by Bill Coulam (www.dbartisans.com) as part of his effort to construct a development framework for PL/SQL...

Having just released version 1.9.1 of Quest Code Tester, our development team is now hard at work on Code Tester 2.0 (tentatively scheduled for release in late Q3 2010).

We are still in the very early stages of our work, but I thought it would be helpful to share some of our concepts and general direction with you - and to ask for your feedback.



I will post this document in the Code Tester forum under...

I've just returned from Collaborate 10, the international Oracle conference organized through a collaboration (hence the name!) between IOUG, Quest (the user group) and OAUG.

It was held at the Mandalay Bay Convention Center in Las Vegas. Now, I must admit, I really don't like Las Vegas (the pretend parts) very much at all. The real parts, like the Red Rock Canyon National Conservation Area,...

Wouldn’t it be nice to have an email message every morning in your inbox regarding the relative health of your databases – specifically only exception type reporting for those that have issues? That way you could “hit the ground running” each morning and address any problems as soon as you read your email. With “Toad® DBA Suite for Oracle” you can easily setup receiving such automated database health check problem reports via email in just a few simple steps. Furthermore, you can also share all such automated Toad task definitions via email.

...

In this blog I'll discuss how to debug a Toad for Data Analysts Automation Script.

In a previous post, we discussed how Toad Extension for Visual Studio helped us analyze the impacts of changes to our code. As part of that discussion, we introduced the idea that sweeping changes may need to occur and iterating through a list of impacted objects isn’t the most efficient means of dealing with these kinds of changes. Before...

"Invoker rights, what's that?" you may be asking.

That wouldn't surprise me, greatly, though one might consider it a bit odd because the invoker rights feature of PL/SQL was added in Oracle8i - many years ago!

So I will first offer a brief overview of invoker rights, why you'd use it, how you use it. Then I will introduce one of the major challenges with invoker rights. Finally, I offer a utility that can help...

Step by step instructions for calling a procedure from a TOAD Manager Report

Republished from John Pocknell's Blog

I thought that’d grab your attention!  



We know there are a lot of PL/SQL developers out there who are looking to make (or have already made) a break into application development using a more popular programming language like Java as well as many Java developers who use Toad to make access to Oracle easier.  

According to a 2006 IOUG survey of Oracle sites,...

Republished from John Pocknell's Blog   The next release of our popular enterprise-class Java profiler is about to hit the streets and we thought we'd give you a heads-up now to let you know what's coming!

The primary focus of this release is all about usability – right from installation and licensing to configuration ready for use. We've significantly revamped the whole user experience which should get you up-and-running...

If you’re anything like me, sometimes, you are your worst enemy. Rarely is this intentional behavior on our part, but sometimes life hands you a loaded pistol pointed at your foot and places your finger on the trigger.