In yesterday’s post I talked about you could use SQL Developer’s Describe (SHIFT+F4) to open a PL/SQL Package at your cursor. If you actually try to describe the package as you see it in the above screenshot, you’ll get an error: I neglected to say in yesterday’s post that I was highlighting the package name [...]
trick
Copying & Pasting Rows Between Grids in SQL Developer
Apologies for slacking on the blogging front here lately. Still mentally hung over from Open World, and lots of things going on behind the scenes here in Oracle-land. Whilst (love that word) blogging is part of my job, it’s not the ONLY part of my job So a super-quick and dirty ‘trick’ this morning. Copying [...]
Using DEBUG Mode in Oracle SQL Developer to Log SQL
Curious how we’re getting the data you see in SQL Developer when you click on something? While many of the dialogs provide a ‘SQL’ panel that shows you the SQL ABOUT to be generated, I’d rather see the SQL AS it’s executed. True, you could set a TRACE or fire up a Monitor Sessions report, [...]
Formatting Query Results to CSV in Oracle SQL Developer
I find that programs that are developed by the same folks that use that program in production are some of the best applications out there. The developer is the user. They have to eat their own dog food – an unpleasant metaphor, but one that’s pretty well understood. Two great examples of that here are [...]
SQLDev Trick: SHIFT+Hover to Peek Into a Stored Proc
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 [...]
Twitter
RSS
GooglePlus
Facebook