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 – 19337520026876cc303f87d_000003 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…
Looking forward to attending KSCOPE12 in San Antonio? Yes? Awesome – I will see you there. I’ll be presenting two sessions: SQL Developer Tips and Tricks Debugging PL/SQL With SQL Developer No? Can’t make it? That’s OK, because I’m working with the awesome folks at ODTUG to bring my SQL Developer Tips and Tricks session to you via webcast! You can sign up for our session on Tuesday, April 24, 2012 12:00 PM – 1:00…
My data hero, Karen Lopez aka @datachick, is hosting a blog meme for this friday called “#FailFriday: I was young and didn’t know any better.” I have made lots of mistakes, but this one still gets to me more than 10 years later. In 2000 I was working for a small ISV in the library management systems space. We had customers all over the world, including Kuwait. Now most of our customers were librarians, not…
I’ve already violated my oath to never use acronyms with the blog title, so for those that do not know what RMAN is, please go read the DOCS. Recovery Manager (RMAN) is fully integrated with the Oracle database to perform a range of backup and recovery activities, including maintaining an RMAN repository of historical data about backups. You can access RMAN through the command line or through Oracle Enterprise Manager. Hmmm, remind me to talk…
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 tree with just your keyboard Optionally using the Schema Browser instead Jumping to package members in the Procedure Editor Using…