Time to download! Mostly bug fixes. the frequent ‘connection reset’ message should be GONE entering text data in a data grid cell and the cursor doesn’t advance should be FIXED having a @ or a ; in a comment in your query should work AGAIN many, many more bug fixes – see the release notes for details SQLcl updated, more bug fixes ORDS 3.0.10 is included, even more bug fixes + Auto PLSQL feature Brand…
Here’s a 15 minute video showing you everything you need to know about using the data grids in Oracle SQL Developer. Basically: settings fonts and look & feel column sizing column(s) sorts client side filtering copy & paste tricks single record view complex data type support – Spatial & BLOBs dates & timestamps inserting multiple rows via PASTE I do NOT talk about the EXPORT feature – because then it would be a 30 minute…
Missed out on KScope17 this week, or were there, but missed out on my talks? Have no fear – you can now catch up on the 3 Oracle SQL Developer features that you should be using, but probably aren’t. I tried my best not to get preachy in this talk, but I must admit it’s still a bit preachy. Oracle SQL Developer: 3 Features You're Not Using But Should Be from Jeff Smith Polling the…
We released a new version of ORDS this week, and I blogged about a new feature in that release – Auto PLSQL. In that post, I briefly mentioned packages, but I wanted to take a quick moment to show that ‘live.’ So assuming you have HR installed somewhere and HR is REST enabled, let’s build this package. 210589435366333fe793c83_000002 And let’s REST enable it…here’s the code, but of course we could also use SQL Developer’s context…
For all of my ORDS demos, I’m running it as a standalone process. There’s no Tomcat or Apache involved – and that’s OK. Your needs may require otherwise, and that’s OK too. When running in a standalone configuration like this, ORDS’ HTTP(S) functionality is being delivered by an embedded Jetty web server. Jetty is an Eclipse project. Very cool stuff – used by LOTS of solutions out there. Anyhow, a customer asked: Hi, Can we…
I wrote this on LinkedIn, but that platform doesn’t play nice with Flipboard, and not all of you are connected with me there. So, if you Twitter, take a second and follow these people. You can thank me later. If you’re looking to follow even MORE people, go read that story, and you’ll see how to fine 194 more.
SQL Developer has averaged about a single major release a year. We’ve also always had an Early Adopter or open beta where we would debut new features, and you could provide feedback. I think this worked – quite well even. But that’s over. Starting later this year, you’ll see us put our product (SQLDev, Data Modeler, SQLcl, ORDS) release updates every quarter. This allows us to keep up with the frequent release cycles we see…
It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick will save you so much time, you’ll be mad I didn’t make you learn it earlier. Apply a Filter to Your SQL History Next week we’re going to work on…
Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on the main File menu. First, we don’t want the main diagram in the report, that’ll give us EVERYTHING. I just want the subview diagram. So after un-checking ‘include main diagram,’…
I had a very, very enjoyable time at the Great Lakes Oracle Conference this week in Cleveland (OHIO! – Just in case Joel is reading this.) About 400 people attended, and I think it’s become one of the best conferences in the US, esp for the bang you get for your buck. I did two talks. For the first one, they had me in the ‘big’ room – right after the day’s Keynote. The Keynote…
