Ugly code, we all write it. I don’t mean bad code either, just hard to read code. Developers who haven’t figured out how to use the TAB and ENTER keys – what’s up with that? — and why is Jeff talking to himself in his Seinfeld voice again? So one of the features in SQL Developer is the Formatter. With a simple right-click (or a Ctrl+F7), you can take your code from ugly to beautiful,…
SQL Developer has had a command-line interface of sorts. The primary use cases were for formatting files and running unit tests. However, we wanted to expand the support to include things like generating Carts and running reports. Instead of just creating a few more one-off interfaces, we kind of started over and built a new CLI from scratch. Random Observation: Developers get very excited when they get to redo something. Rather than call the main…
Being asked when the next version of your product is going to be released is a gut-wrenching question. The community gets excited when a new release is due – who doesn’t like new things to play with? And I’d love to tell everyone when exactly that will happen. But, the very the second I shared THE DATE, I’d be branded a liar. You see, dates slip. And being in a position to not ship product…
So go download it. I’m at the beach this week, not working. Mostly. I’ll be talking about our newest addition to the family, pretty much non-stop, starting next week and stopping when version.NEXT is released. You have plenty to look forward to 🙂 For now, just a few points: We’re not distributing the JDK on Windows 32 bit distributions anymore We now require Java 1.7 JDK by default Windows installs will attempt to auto-find the…
I get this question a lot. The question tells me a few things: you LIKE the animated GIFs here on thatjeffsmith – cool, I’ll keep doing more you want to make your own – awesome, I’m helping make the world a more animated place that’s pretty much it, I should have said a couple of things, oh well I use Camtasia Studio 7 from TechSmith If you want a more official ‘answer’ to this question,…
Organizing your data model makes the information easier to consume. One of the organizational tools provided by Oracle SQL Developer Data Modeler is the ‘SubView.’ In a nutshell, a SubView is a subset of your model. The Challenge: I’ve just created a model which represents my entire ____________ application. We’ll call it ‘residential lending.’ Instead of having all 100+ tables in a single model diagram, I want to break out the tables by module, e.g.…
SQL Developer has had an object search for quite a while, however we decided it wasn’t good enough, so we enhanced it! You can now search more things, and the search results are easier to work with. Here’s a quick demo to see it live in action: How it works For your your connection, you’ll need to set a few search parameters, the SCHEMAs you want to look into, and then what you want to…
You’re doing some data clean-up, or maybe you’re just trying to answer a business question for a user, and you notice the data doesn’t look quite right. You want to click in that ‘(null)’ cell and tell the world that Tyler and Perry composed that song! But, we’re in a query result set, and not a table editor. I’m the ultimate lazy-dev, so what’s the easiest way to get what I want? Throw In a…
In a few weeks I’ll be speaking at the Database Symposium at the ODTUG KScope13 conference. My topic, ‘SQL Developer v4.0’ will be one of the first times I spend an entire hour showing off our new features in the upcoming release. While not yet publicly available, and while I can’t comment on when that will change, I can say we’re getting closer 🙂 I thought I would reward my loyal readers with a quick…
Interesting question from the forums: I’m doing multiple Inserts on a table using a script file (.sql) in SQL Developer. Since it has a lot of statements, I would like to check the progress of it somewhere in the application window. But I don’t see any progress of lines being displayed anywhere. The focus simply stays on in the first line. It would be helpful if the script execution either points to the current DML…
