I was going to talk about our new IMPORT command in SQLcl. This will allow you to feed a delimited text file of data to our command line interface and have it automatically imported to a table. But Kris Rice beat me to it. Woo-hoo, less work for me 🙂 So go read that now. If you read far enough, you’ll see a really cool video on how to create a session monitor in SQLcl.…
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.…
Everyone likes pictures. Generate a report without any pictures, graphs, or charts and see how many ‘likes’ you get at work. Everyone gets excited about data modeling, and in some circles, folks think that data models are synonymous with diagrams. But really, the diagram is just the ‘pretty picture’ you add to your office report. Don’t get me wrong, these pictures CAN be very important. There are lots of things you can do to customize…
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…
I recently talked about how to load up your Oracle Cloud service with your local data. In that scenario, you’re in the graphical user interface, clicking buttons, doing things more ad-hoc. But what if you wanted to build an automated process to load up data from an on-premise Oracle Database? You won’t have a GUI available then, so what’s available? Enter the SQL Developer command-line interface, also known as SDCLI. In the SQLDEVELOPER/BIN Directory Here…
How to add common columns to your tables or entities and/or tables in SQL Developer Data Modeler.
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…
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.
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…
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…