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…
In a previous episode, I showed how quickly you can REST enable your Oracle Database tables and views. And I took a second or 3 to show how to create a module in SQL Developer’s REST Development panel, which allows you to have a RESTful endpoint served by a SQL statement which will bring your data back as JSON. Today I want to take another 30 seconds to show how to add a :BIND to…
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…
View – DBA – Security – Auditing A user asked how to use SQL Developer to audit user XYZ. And to be honest, it’s not really set up to work that way. You define operations or objects you want audited. Any user that does XYZ to object ABC will get logged. There’s an exception to this – you can setup SYSDBA users to be audited. This will grab the SYSDBA-level type operations that happen. Check…
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.…
I don’t like deleting blog posts just because they’re old, or no longer true, but this one came before we made this SO MUCH SIMPLER. Please read this post instead. TL/DR? You can now just say SET DDL STORAGE OFF if you want to set the metadata transform bits 🙂 We’re getting much closer to having Oracle SQL Developer version 4.1 ready for release – which includes SQLcl, our new command-line interface for Oracle Database.…
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…
You can save query results or any other grid in SQL Developer as a PDF. You don’t get much in terms of saying how the generated PDF should look – Said PDF file: But I have some important info in here, and it should look a bit nicer. Save Your Query As A Report And then format your report, using the PDF properties. You can set a customer header and footer, define the fonts to…
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…
How to add common columns to your tables or entities and/or tables in SQL Developer Data Modeler.