We’ve been working on version 4.1 since last Fall, and I’ve been blogging about the new stuff all the while. In case you missed it, we officailly released version 4.1 yesterday 🙂 Here’s a quick index of all of those version 4.1 posts you may have missed: SET SQLFORMAT command and a new formatter, JSON a new Search and Replace interface Code Insight, more tweaks & improvements Easier Excel and CSV Imports Multi-Cursor (text, styping…
Oracle SQL Developer version 4.1 is now available. So is SQL Developer Database Modeler version 4.1. And so is Oracle REST Data Services version 3.0. Java Requirements For SQL Developer Java 8 is now supported. It’s also required. If you need to, you can install Java 8 without removing Java 7 and ‘breaking’ your other Java applications. You can even install Java 8 on a similar machine, copy the Java home directory, and and paste…
We have a script execution directory setting in SQL Developer…but what about our new SQLcl command line utility? That was a question posed to me this morning. My answer was..well, let me show you my answer. 1004934106677eb80a6e447_000000 Now you can see why: My prompt is what it is My output is formatted nicely My script is able to be found In Case This is All New to You… SQLcl is a new take on SQL*Plus…
Updated 28 May 2022 The ORDS installer has been rewritten for version 22.1, and will no longer be installable via SQL Developer going forward. REST. Or, Representational State Transfer. It makes a lot of the INTERNET today possible. When you see an application making PUT or GET requests over HTTP or HTTPS, that COULD be REST. REST is an architectural style. You perform actions (GET, PUT, POST, DELETE) against resources, like a TABLE. So you…
Hopefully you’ve heard about the new SQL*Plus we’re building. And hopefully you’ve heard about the new REPEAT command we put into it yesterday. Here’s a quick example of how to build a little ‘monitor’ in just 2 commands, a total of 5 lines of code. The SQL 1004934106677eb80a6e447_000001 So run that, make sure you like the formatting, and the data of course 🙂 Then to turn that into a refreshing report, run this: SQL>repeat 100…
I was going to talk about our new IMPORT command in SQLcl. This will allow you to feed a delimited text file of data to our command line interface and have it automatically imported to a table. But Kris Rice beat me to it. Woo-hoo, less work for me 🙂 So go read that now. If you read far enough, you’ll see a really cool video on how to create a session monitor in SQLcl.…
Question: How can I make SQL Developer display the number of rows returned by a query? Answer: Execute the query, and fetch all the rows. But I’m not seeing it! and fetch all the rows. This part is important. Execution using ctrl+enter executes statement, and returns the FIRST ‘fetch’, by default of 50 records. First Fetch Last Fetch Warning: Rant ahead! …Until All Rows Are Read – there’s one or more proceses on the server…
Everyone likes pictures. Generate a report without any pictures, graphs, or charts and see how many ‘likes’ you get at work. Everyone gets excited about data modeling, and in some circles, folks think that data models are synonymous with diagrams. But really, the diagram is just the ‘pretty picture’ you add to your office report. Don’t get me wrong, these pictures CAN be very important. There are lots of things you can do to customize…
As we get nearer to releasing our next update for Oracle SQL Developer, there are a few FAQ’s I’d like to answer. When IS version 4.1 going to be available? Soon. Right NOW, actually. Will there be a Windows download available that includes a JDK? Not today, but there will be a 64-bit bundle available soon. Why are you making us run Java 8? Because Java 6 and 7 are old, and Java 8 is…
I recently talked about how to load up your Oracle Cloud service with your local data. In that scenario, you’re in the graphical user interface, clicking buttons, doing things more ad-hoc. But what if you wanted to build an automated process to load up data from an on-premise Oracle Database? You won’t have a GUI available then, so what’s available? Enter the SQL Developer command-line interface, also known as SDCLI. In the SQLDEVELOPER/BIN Directory Here…