What's New
For the 90%+ of people using sqldev/modeler on windows, the JDK bundled versions are back. So no more debating what to install or worrying about conflicting Java versions.Lots of bug fixes.
My favorite bug is now fixed so you can use emojis in your sql> prompt.
RESTful CSV Loading
We wrapped he same CSV import code in SQL Developer into the REST Auto-Enablement feature. Here's a very short example of javascript batch inserting 4 records into the EMP table. I'm not sure it can get much easier.
// CSV (POST http://localhost:8888/ords/klrice/emp/batchload)
jQuery.ajax({
url: "http://localhost:8888/ords/klrice/emp/batchload?" + jQuery.param({
"responseFormat": "RAW",
}),
type: "POST",
headers: {
"Content-Type": "text/csv",
},
processData: false,
data: "empno,ename,job,mgr,hiredate,sal,comm,deptno
5001,M,SPY MAST,,2005-05-01 11:00:01,4000,,11
5002,J.BOND,SPY,0,2005-05-01 11:00:01,2000,,11
5003,R.Cooper,SOFTWARE,0,2005-05-01 11:00:01,10000,,11
5004,Max,DENTIST,0,2005-05-01 11:00:01,5000,,11
",
})
.done(function(data, textStatus, jqXHR) {
console.log("HTTP Request Succeeded: " + jqXHR.status);
console.log(data);
})
.fail(function(jqXHR, textStatus, errorThrown) {
console.log("HTTP Request Failed");
})
.always(function() {
/* ... */
});
Here's the same example in Paw which is a great client if are on OSX
While this is a very simple case, there are a lot of switches to customize this importing. Those options are all in the doc found here: http://docs.oracle.com/cd/E56351_01/doc.30/e56293/develop.htm#BABCACEC
Go Forth and Download
 |
| SQL Developer 4.1.1 |
 |
| Data Modeler 4.1.1 |
 |
| REST Data Services 3.0.1 |
 |
| SQLCL - Main Line Build |
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
( Last Link on the bottom of the sqldev download page )
