Everyone knows that SQL Developer has a PL/SQL debugger – check! Everyone also knows that it’s only setup for debugging standalone PL/SQL objects like Functions, Procedures, and Packages, right? – NO! SQL Developer can also debug your Stored Java Procedures AND it can debug your standalone PLSQL blocks. These bits of PLSQL which do not live in the database are also known as ‘Anonymous Blocks.’ Anonymous PL/SQL blocks can be submitted to interactive tools such…
DBMS_OUTPUT is one of the most well-known and least understood SYS packages. If you have questions about how it works in general, you might want to read my previous post on the subject. What I want to show you today is a ‘trick’ that will help you bypass the step of enabling polling for DBMS_OUTPUT for all of your connections. I’m all about saving clicks, so let’s save you 3 clicks right now. Instead of…
Bequeath is an interesting word. It’s hard to pronounce for starters, or at least it is for me. So if you want to trip me up during a seminar, ask me about how to connect to Oracle sans Listener. Then you’ll get to hear me try to say bi-ˈkwēth, -ˈkwēth, bē- from Merriam Webster Your database hasn’t died (at least I hope it hasn’t, if it has, you’re in the wrong place). Instead, there’s a…
I’m a keyboard ‘ninja.’ I know how to get a lot of characters to splat up on my screen in as few keystrokes as possible. Yet sometimes I do fall back to the mouse. Cue the command-line SQL*Plus diehards rolling over in their graves. One of my favorite tricks is the ability to drag 2 or more tables into the worksheet and have SQL Developer automatically create a SELECT with the WHERE clause joins pre-built…
Incremental find. What is that? It is one of many features in SQL Developer that I have managed to overlook. It has been right there though, staring me in the face. I’m betting that many of you have seen it without really SEEING it, just like I have been doing. Until today that is! Let’s take a look at the word ‘incremental’ first: From http://dictionary.reference.com in·cre·men·tal [in-kruh-men-tl, ing-] adjective increasing or adding on, especially in…
What is Oracle SQL Developer? If you’re brand new to Oracle or are just now discovering the joys of using a GUI over the command-line interface, this video will show you a high level overview of SQL Developer’s main feature areas. Those include: an IDE for querying, scripting, debugging, and executing statements and programs a database navigation tree and object editors for pointing and clicking your way through database an extensible framework where users can…
You want to run a query or two against an Oracle database. You want to get the data back into a user-friendly and consumable format, such as a comma separated values file. You can do this in SQL Developer, VERY easily. You can watch the movie… …or read on – your choice! Quick ResultSet Exports as Script Output I’m too lazy to hit execute > SaveAs > Open File. I just want to get my…
If you have problems in your PL/SQL program that prevent compilation and execution of said program, then that is reported back as an ‘error.’ It could be as simple as missing a semicolon – 126691350468f4bacd039d0_000012 When you run this through SQL Developer, an error message is returned a la Well that’s an easy fix. We’re all done! Or are we? Enter the world of PL/SQL compile-time warnings: To make your programs more robust and avoid…
I’m poking around an unfamiliar schema or environment. I’m not sure what these procedures do. I could open them, but I’m lazy and I don’t want the tool to open another document/window. The ‘mystery’ code: These programs are self-documenting as they have the most awesome names ever! I’m guessing that one package will blast my enemies?, but I’m not sure. If only I could peek into the source without opening it!!! Hmm, what’s this thing…
Updated: May 11, 2015 I’ve been giving this presentation for about 4 years now. It’s morphed, mutated, and improved incrementally for that entire time. I say I have a ‘top 10’ but it’s closer to 15 or so. It’s a VERY interactive session, with live demo. And there’s always lots of questions as we go. But, if you’re not able to see this in person, I do have a slidedeck on slideshare – you can…