Some of you are real fast typers, and don’t need this type of help. However, some of you, no matter how fast you can type, have to deal with column names that are long, hard to spell, and to just work with in general. So let’s say you’re working on a report, and the column order is very specific. Now, …
Trick: Adding Columns to Query in the Desired Order
I tried to reference this post, and couldn’t find it. So apparently I have to write it now. I want to write a query. I want a bunch of column names. I could do this: But I’m very particular. Or maybe my customer is very particular. She wants SALARY then LAST NAME then FIRST NAME then EMPLOYEE ID. And so …
Multi-Select Object Actions via XML Extensions
You want to drop, purge 10 tables, and you don’t want to select, click, click, click 10x. What’s a SQL Developer user to do? Well, if you want to live dangerously, you could build a custom extension for SQL Developer to do that for you. We tweaked the IDE to allow this in version 4.1.2 – if you’re on any …
Using the Modeler to Compare Two Schemas
A question came up on the oracle-l… I am working in SQL developer 4.0. I am comparing my acceptance version of a schema to my production version of the same schema. We did some ‘clean-up’ of old tables and views in acceptance. We want to apply the same changes to production, when we go to prod. How do I tell …
Generating Object DDL Scripts with Drop Statements
Is there a way for SQL Developer to generate a DROP statement when exporting the DDL for a table? Yes. The drop preference will be applied when generating the DDL for scripting purposes, but not for the table editor. So to get the table CREATE DDL script with a DROP TABLE command, right-click on your table, and send the ‘Quick …
Oracle SQL Developer: Query Builder Video Demonstration
I’ve talked about the query builder a bit here on these pages, but sometimes a quick video can do a much better job demonstrating these concepts. The video is about 8 minutes and covers: writing a query the old-fashioned way writing a query with drag-and-drop from the tree using the Query Builder At about 5 minutes in, I talk about …
Dragging and Dropping Files into Oracle SQL Developer
There are many ways to open a file. File > Open is one, but apparently that’s too boring for many of our friends out there. For you new-fangled mouse people, let’s look at drag-and-drop. From the View > Files Panel Ok, But What About from Explorer or Finder Same difference, but there is one ‘trick’ to remember – you’ll need …
SQL Developer Data Modeler v3.3 Early Adopter: Link Model Objects Across Designs
The third post in our “What’s New in SQL Developer Data Modeler v3.3” series, SQL Developer Data Modeler now allows you to link objects across models. If you need to catch up on the earlier posts, here are the first two: New and Improved Search Collaborative Design via Excel Today’s post is a very simple and straightforward discussion on how …
Oracle SQL Developer v3.2 is Now Available!
Today we released the latest version of Oracle SQL Developer – v3.2.09.23. The official resources: SQL Developer on Oracle Technology Network (OTN) Release Notes New Features SQL Developer Forum I’ll showcase a few of my favorite new features and tweaks in the next several days and weeks, but I thought I’d kick things off right now with a new ‘trick!’ …