I don’t like deleting blog posts just because they’re old, or no longer true, but this one came before we made this SO MUCH SIMPLER. Please read this post instead. TL/DR? You can now just say SET DDL STORAGE OFF if you want to set the metadata transform bits 🙂 We’re getting much closer to having Oracle SQL Developer version 4.1 ready for release – which includes SQLcl, our new command-line interface for Oracle Database.…
Question: How can I make SQL Developer display the number of rows returned by a query? Answer: Execute the query, and fetch all the rows. But I’m not seeing it! and fetch all the rows. This part is important. Execution using ctrl+enter executes statement, and returns the FIRST ‘fetch’, by default of 50 records. First Fetch Last Fetch Warning: Rant ahead! …Until All Rows Are Read – there’s one or more proceses on the server…
You can save query results or any other grid in SQL Developer as a PDF. You don’t get much in terms of saying how the generated PDF should look – Said PDF file: But I have some important info in here, and it should look a bit nicer. Save Your Query As A Report And then format your report, using the PDF properties. You can set a customer header and footer, define the fonts to…
As we get nearer to releasing our next update for Oracle SQL Developer, there are a few FAQ’s I’d like to answer. When IS version 4.1 going to be available? Soon. Right NOW, actually. Will there be a Windows download available that includes a JDK? Not today, but there will be a 64-bit bundle available soon. Why are you making us run Java 8? Because Java 6 and 7 are old, and Java 8 is…
How to add common columns to your tables or entities and/or tables in SQL Developer Data Modeler.
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…
In honor of today’s holiday, a hat tip to our Irish friends! Spot the places I’ve configured SQL Developer to show green I can spot 7 different spots in the above screenshot where I have configured SQL Developer or manipulated the output to show the color green.
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…
Our team pushed a TON of updates – fixes and new features – this afternoon. SQL Developer 4.1 EA2 SQL Developer Data Modeler 4.1 EA2 Oracle REST Data Services EA2 SQLcl updated 3/9/2015 (it’s listed after the SQL Developer downloads) What time is it? I have much, much, much more to say on these products and updates. But for now, go download, and provide feedback to the Community forums. Java 8 SQL Developer 4.1 has…
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.