SDSQL was our first name for SQLcl. This Early Adopter preview release went to to become production ready, and used by customers for 6 years and counting! Go here to catch up on what we’ve done with SQLcl since 2014. Instead of talking about or teasing some of the cool new features of SDSQL… Wait, what is SDSQL? …I thought I would start with the basics. Like: How to install it (on Windows)How to connect…
The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer’ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no matter how much money was invested in BI, reporting, and databases – at the end of the day, it’s going…
Oracle SQL Developer is a graphical user interface and integrated development environment for Oracle Database. As you can imagine, a few clicks can results in an awful lot of queries being executed on your behalf. If you don’t like this fact, you can always use a command-line interface like SQL*Plus or the new sdsql. The only thing that runs there is what you explicitly type..mostly. Anyways, in version 4.1, you can now see all of…
Updated December 1, 2020 – after some reports from folks having issues on Big Sur, I added some additional details around troubleshooting. I have ran into a few issues getting SQL Developer version X.Y.Z on my Mac Mini, and I’ve seen a few questions online today now that Big Sur is available. This usually happens as folks get new hardware or as updates are applied to their machines…something quits working. It usually boils down to…
Go get it. Then come back here and read a couple of things. it REQUIRES Java 8 it’s not production ready – send feedback to the Forum not to Support Two new features to help you get started. SQL Formatting in the Worksheet Like the /csv/ formatting ‘hints’ you can add to your statements? Well now, you can just toggle that output mode for an entire session. You ‘unset’ the formatting by using the ‘set…
We have a new version of SQL Developer Data Modeler for you to check out – version 4.1. It’s an ‘EA’ – or early adopter. So, no official support – all feedback should be provided via the OTN Forum/Community. It requires Java 8. If you see a message about not supporting Java 8 – ignore that and just click ‘OK.’ You can read all about it and download it here. I’ll be blogging about the…
I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, we’re not super fond of these ‘arrow’ buttons to launch the compares. I don’t think they’re as intuitive as they…
Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again. While we’re on this page, there’s lots and lots of cool things you can fiddle with here. For example, ‘SELECTED TEXT.’ And of course you can use this preferences page to setup a more classic ‘green-screen coding’ display..…
Looking at endless spreadsheets or grids of data can make one’s brain a bit fuzzy. SQL Developer makes it easy to spot the bad data you’re looking for. Hit Ctrl+F in a grid. Type your search term. If you’re going to be looking for this data going forward, check the ‘Persist Highlight’ box. So for example, if I’m getting ready to demo some Tips & Tricks and I want to call out the very nice…
Updated 17 April, 2020: This feature now supports AutoReplace Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works! But, I was getting distracted by a bit of code that LOOKED like it was DOCS related, yet wasn’t… So if it’s not coming from the docs, where is it coming…