You have a schema. Someone else built it. You’ve just inherited it. Now you need to build an application around it. But, tell me more about this schema? No docs? That’s OK, you can build your own! 1. Connect to Your Database, Open a ‘Driving’ Table By driving, I mean one that’s likely to be at the ‘center’ of your business logic. An employees or sales table for example. Now, once it’s open, click on…
In the year 2000… No, let me start over. IN the year 2017, we have Oracle SQL Developer version 17.2. It started as Project Raptor in 2005. It’s got a pretty wide and deep feature set covering these areas: PL/SQL IDE SQL editor GUI for browsing and managing database objects Ad Hoc reporting Database Design & Data Modeling Database Administration 3rd Party RDBMS Migrations to Oracle Deploy and Administer Oracle REST Data Services REST Enablement…
Apparently SQL Developer doesn’t look super awesome on some Windows high-resolution displays (Macs are apparently A-OK!) 4 and 5k monitors. But that’s OK – it’s fixed in Java 9, and that appears to work just fine with SQL Developer v17.2. But another question came up – how can I make SQL Developer look…different? There isn't an overall theme for all the parts of the app? I really want everything changed (connections and reports).— PIONTΞKDD (@piontekdd)…
I get the impression that many of you have thought about getting more acquainted with our development tools and platforms here at Oracle. But I ALSO get the impression that many of you just haven’t had the time. So, I’m officially inviting you to participate in a series of upcoming webinars I’ll be hosting. How they ‘work’ We’ll use a online conference solution that lets me share my desktop with you. I’ll be doing live-demo…
Having an extra bit bucket in your tables is pretty easy now in Oracle Database 12c and higher. We offer native JSON support [JSON DOCS] – you can have a free form text column and store anything you want in it. AND, we pretty much give you the full power of the SQL interface to those bit bucket items – pretty neat I think. I’m still big fan of the relational paradigm, and I think…
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…
We tried 15 minute talks at a conference last week, and I think they came out OK. I figured for the folks who weren’t able to come out to the conference, maybe you’d like to see the talk? So here it is. The basic gist of the talk: SQL Dev is a BIG, DEEP tool You don’t have time to figure out all the ‘cool’ stuff I DO have the time Here’s the cool stuff…
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…
New Oracle REST Data Services (ORDS) drop today. Per usual, mostly bug fixes And per usual, sometimes we like to sneak in new features as well, and this release is no different. You can now have ORDS automatically create POST handlers for executing your PL/SQL. This is a LOW CODE solution. You could of course ALWAYS roll your own RESTful Service to run your PLSQL, and in many cases, you’ll continue to want to do…
A quick demonstration for configuring Oracle REST Data Service’s embedded Jetty web server – adding access logs for ORDS, with just a single XML file.
