Oracle SQL Developer Data Modeler supports the one-gal design boutique shoppe and the mega-huge development team. It HAS a file-based repository (Subversion aka SVN.) You don’t have to use it, but you should. You can optionally store your designs and data dictionaries in a database for reporting purposes. I strongly recommend you do so. If you do add your design to a repository, once you save it, and BEFORE you COMMIT your changes to the…
You have some data. You want to email it to someone. You don’t want them to have to open an attachment. You want it to be in an HTML-Tabl’ish delivery device. In SQL Developer, write your query. Export to HTML > File. Open Outlook. Start your message. Attach File Point to your HTML File DON’T CLICK ON THE INSERT BUTTON On the INSERT button, there’s a drop-down widget. Click that instead. And then choose, ‘Insert…
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…