ThatJeffSmith

Tag: PL/SQL

SQL Developer Video Tutorial: Navigating Your PL/SQL

If a picture is worth a 1,000 words, how valuable is a 6 minute video? Instead of throwing up a bunch of bullet points and screenshots on the blog, I’m going to let you watch the movie instead. In just a few minutes, learn how to maximize your SQL Developer experience by Navigating the connection […]

JAVADOC for the Oracle Database a la DBDOC

Javadoc is a tool for generating API documentation in HTML format from doc comments in source code. Wouldn’t it be nice if a similar tool existed for PLSQL? Well you’re in luck because someone already made that available via an open-source utility known as pldoc. Automatically document your database schema with SQL Developer using the […]

Using Pass Counts to Turbo Charge Your PL/SQL Breakpoints

Debugging PLSQL is one of the primary features of Oracle SQL Developer. Yes, its the IDE for the database, but PLSQL is the database’s programming language. It really, really needs to support all things PLSQL. Programming languages need modern day amenities if they are to be adopted by mainstream developers. One of those amenities is […]

Viewing PLSQL Compilation Errors in Oracle SQL Developer

A question that comes up fairly frequently revolves around how to see your errors when working with PL/SQL in SQL Developer. Most folks are probably working in the worksheet – this is the default editor for your connection. Let’s take a look at this sample program If we were to create this procedure, we would […]

SQL Developer Tip: Viewing REFCURSOR Output

If you work with PL/SQL, then this feature might be the #1 reason I recommend you immediately upgrade to at least version 3.0 of Oracle SQL Developer – SQL Developer now automatically renders SYS.REFCURSOR output from your PL/SQL calls. Prior to version 3.0, you needed to use the SQL*PLUS PRINT command to view the refcursor […]

The PL/SQL Debugger Strikes Back: Episode V

I’ve already discussed how the Rebel scum go about figuring out what’s wrong with their code. Now I want to get into the nitty-gritty details of how to start a debug session in SQL Developer. There are some prerequisites, but I promise it won’t take but a few moments to setup. Ensure that you have […]

Debugging PL/SQL with SQL Developer: Episode IV

Can you tell us more about the debugger? Can you show us the debugger? What about the debugger? Can you spell ‘debugger’? Why can’t the debugger show X? What is COMPILE WITH DEBUG anyway? Debugger? Skip to Episode V – Starting the Debugger In the past 10 years I have probably heard these questions and […]

Toad for Oracle v11 Sneak Peek: PL/SQL Grammar Checking

Are you a PL/SQL developer? Do you think your IDE should promote better coding practices, and guide you to build more robust and reliable programs? If so, then Toad v11 might be just the IDE you are looking for. Toad version 11 introduces a new feature in the Professional and higher editions – Code Analysis. […]

Kscope11 Database Development Symposium

The Oracle Development Tools User Group’s (ODTUG) annual convention in Long Beach, CA kicks off on a Sunday with several Symposiums. There will be one dedicated to tools (link), and I’ve been asked to present Toad and how it helps with instrumenting your PL/SQL code. – ODTUG KScope11 June 26-30 (Details) – One of the […]

More PL/SQL Fun in Toad version 11

You have some SQL in your PL/SQL program, and you need to execute it to see if it’s doing what you want. Today that means you need to extract the inputs, replace with binds, and remove the INTO syntax. What if Toad had a ‘magic button’ to do this work for you? In version 11, […]

Toad Tricks for PL/SQL Professionals

My first experiment with SlideShare! Interested in a free training session for Toad for Oracle? In about 60 minutes I can go over most of the features Toad has to offer for someone who works with PL/SQL. Take a look at the below presentation, and if you are interested, let me know. I can schedule […]

‘New’ Technology from 2000

I spend a lot of time speaking to PL/SQL development teams. A conservative estimate would break down to about 200 presentations a year and 2,000 developers. I have several stock presentations, but I prefer to have conversations with my audience rather than just start throwing slides up on the projector. If we find a topic […]