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 DDL’ to a worksheet, clipboard, or file. There’s also a ‘Cascade Drops’ preference, which is…
Reports are one of my favorite features. If you don’t use them in SQL Developer, please read this. The user interface for user defined reports is very simple in SQL Developer. Maybe even, too simple? Sometimes I tell folks to save and/or copy their reports around. And it’s not exactly apparent how to do this at first glance. Of course, once you’ve done it once, it’s very obvious. As a product manager, sometimes it’s easy…
You may wish to store your PL/SQL code in files with file extensions other than our defaults. We ship with .klr, .pkb, .pkh, .pks, .plb, .pls as associated file types for our PL/SQL editor and for opening said files on your machine with SQL Developer. But maybe at XYZ Incorporated, you keep your package bodies in files of type .bdy Are you stuck using our SQL Worksheet for doing serious PL/SQL work? No! Just setup…
A few weeks ago I published a story highlighting all of the different ways SQL Developer can help you with your code. That post generated a lively discussion around this: Pre Version 4.1 Let’s try that again: Version 4.1 Early Adopter 2, specifically We’re also making sure to sort the local schema objects ALWAYS to the top of the pick list. P.S. Wondering why that last screenshot has a funny worksheet name? You can change…
I’ve taken a TON of screenshots of both SQL Developer products to demonstrate features. I was playing around with Flickr to see if there was a better way to re-purpose this content other places. Here’s what that COULD look like. I have a few hundred more to add to this photo album. This is just a test 🙂 If I find this portable, we can add it other, more official places.
Our developer advocate team, led by Steven Feuerstein of PL/SQL fame, is looking for someone to help spread the good word – about SQL. You can read about the job here, but I thought I would throw in my two or even 3 cents on the matter. I have been evangelizing or advocating or helping – funny how those words are so similar but subtly different tastes in one’s mouth – database development tools for…
Everyone likes pictures. I would never create a report that didn’t have at least one chart in it. You just can’t risk busy people glancing at your reports and not coming away with the key information you’re trying to impart. We have lots of chart types in SQL Developer – 50+ in version 4.0. But we also have gauges, and I’ve talked about them before. But what about dials? So we can graph numbers, but…
Today’s post is brought to you by a new request to the Exchange this week. They wanted to be able to quickly filter a list of objects without having to open a dialog to do it. For a dynamic browsing of databases with a lot of objects it would be nice to have a textbox where you can filter the current object by name (may be in memory) without using a dialog The filter dialog…
Kellyn PotVin-Gorman and I have delivered a social media talk at the RMOUG Training Days Conference two years running now. We have fun doing the presentation, because we have fun being active on social media. We want you to not miss out on what we get out of it every day. This morning I saw a tweet/blog post from Oracle ACED Scott Spendolini of Oracle APEX fame… Screaming at Each Other http://t.co/Dqsw4xwYmR #orclapex— Scott Spendolini…
One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output format? Now that we have our own SQL*Plus command line interface (AKA SQLcl), the commands that are available there are…
