ThatJeffSmith

Category: Database Stuff

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 [...]

Running & Managing Concurrent Queries in SQL Developer

We’ve all been there – you’ve managed to write a query that takes longer than a few seconds to execute. Tuning aside, sometimes it takes longer than you want for a query to run. So what’s a SQL Developer user to do? I say, keep going! While you’re waiting for your query to finish, there’s [...]

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, [...]

Searching Your PL/SQL Source with Oracle SQL Developer

Version 3.2.1 included a few tweaks along with several hundred bug fixes. One of those tweaks was the addition of ‘ALL_SOURCE’ as a selection for the Type drop down in the Find Database Object panel. Searching the database for your code or objects can be expensive. The ALL_SOURCE view comes in pretty handy when I [...]

Search and Browse Database Objects with Oracle SQL Developer

Having trouble finding something? Maybe you’re just getting older? I know I am. But still, it’d be nice if my favorite database tool could help me out a bit. Hmmm, what’s this ‘Find Database Object‘ thing over here…sounds like a search mechanism of some sort? You can access this panel from the ‘View‘ menu. It’s [...]

Database Diff Enhancements in Oracle SQL Developer v3.2

In the current issue of Oracle Magazine, I have an article that discusses how to copy and compare Oracle objects using Oracle SQL Developer. ‘Make the Easy Move‘ was written using Oracle SQL Developer v3.1. As you know, version 3.2 was released several weeks ago, and one of the significant changes included was an update [...]

Grandparent – Parent – Child Reports in SQL Developer

Parent – Child reports are pretty straightforward in Oracle SQL Developer. You have a ‘parent’ report, and then one or more ‘child’ reports which are based off of a value in a selected row or value from the parent. If you need a quick tutorial to get up to speed on the subject, go ahead [...]

Grants Now Included in SQL Developer SQL Pages

Quickly copying objects to a new environment is easy in SQL Developer. You simply go to the object in the tree and access the SQL page. However a few of our users were complaining that we weren’t including the object privileges that had been GRANTed in the SQL script. So after re-creating the object in [...]

Using Oracle SQL Developer to Setup SQL*Loader Runs

I’ve done a couple of posts on how to use SQL Developer to load your Excel files to an Oracle table. However, I always wonder how many folks realize there may be a ‘better way.’ If you are loading data to Oracle on a regular basis, there’s a few things I want you to know [...]

‘Forcing’ Line Breaks in Oracle SQL Developer

Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly. One of the many code ‘helpers’ that a good IDE will provide is a Formatter. Formatters, or code beautifiers as they’re also known, take poorly [...]

SQL Developer Trick: Renaming Your Worksheets

After a VNC session with the always brilliant @bamcgill, I now know how to rename a worksheet. So when you open a worksheet, it’s attached to a database connection. The worksheet name is a property, and it defaults to the connection name. So you DO you have a lot of control over the worksheet name. [...]