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 – 84544341268cc26f2e6635_000007 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…
Updated: July 29, 2012 Defining what success means to you and your blog is something you have to do before you can answer questions like ‘Is this working?’ If you’re using your website or blog to sell widgets, it’s pretty easy to measure. Are we selling more widgets or do customers on average spend more per transaction, or do we make more money with less products – these are all pretty easy metrics to measure.…
Oracle SQL Developer allows a user to save their passwords for their Oracle database connections. I don’t want to continue the ‘is it bad to save passwords’ debate, but I will share a ‘trick’ for making some of you a bit happier. Just add the following line to your ‘sqldeveloper.conf’ file, which lies in the SQLDEVELOPERBIN folder: AddVMOption -Dsqldev.savepasswd=false On application start-up, SQL Developer will see this flag and hide the option to save your…