ThatJeffSmith

Tag: sqldev

SQL Developer 4.0 and the Command Line Interface (CLI)

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 […]

Semantic Analysis Info Tips in Oracle SQL Developer 4.0

A new feature in Oracle SQL Developer version 4.0 offers to address grammatical issues with your SQL statements. We call these indicators ‘Semantic Analysis Info Tips.’ The easiest way to see one of these ‘tips’ is to try out your favorite sql statement in a worksheet: Accessing the ‘Tip’ Place your mouse over the red […]

When Is The Next Version Coming?

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 […]

Oracle SQL Developer 4.0 Is Finally Here

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 […]

Oracle SQL Developer Lineup at Oracle Open World 2013

Oracle Open World 2012 left me exhausted. Apart from the social and fun stuff like running across the Golden Gate with a few co-workers and keeping up with social and business dinners, we had a ton of presentations, Hands On Labs, and of course the demo pods to man in the Exhibitor Hall. 2013 takes […]

Oracle SQL Developer and Java 7

The current version of Oracle SQL Developer requires at least Java 6, e.g. the 1.6 JDK. I talk about Java, JDKs, JREs and what all that means in a previous post if you need to catch up on the lingo. Many versions of Java out there – 5, 6, and 7 are the most common. […]

SQL Developer: I’m Looking at a Record, How Do I Edit It?

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 […]

Querying Your Oracle SQL Developer Data Modeler Designs

Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then […]

A Sneak Peek: Oracle SQL Developer Version 4.0

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 […]

Monitoring Scripts as They Execute in Oracle SQL Developer

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 […]