I sometimes get a double-take when I do a blog post or tweet or show a picture of SQL Developer running on my Mac. My Macbook is my personal machine: I don’t normally do live-demo’s on it, but I almost always do my blog posts and screenshots from there. For official webcast stuff and conferences, it’s the old workhorse Win7 machine. And it looks like this for the most part: But you as a user,…
Here’s a quick run-down of FAQ’s I get when doing presentations or demos. Can SQL Developer… Extend a tablespace? Yes. You can edit an existing data file or add a new one. We’ll also show you the SQL that’s going to be used so you can copy it to run in SQL*Plus or wherever. And if you wanna just do it in a SQL Worksheet, we can help you with the syntax there too. Debug…
I have talked about how to preview BLOBs (Binary Large Objects) as pictures… But someone on Stackoverflow asked how to read a BLOB value if it had text. So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then loaded that to a table as a BLOB. Then I browsed the table, double-clicked the cell… and voila, the data being stored… Other BLOB posts: setting up external editors (Adobe…
I answered this question on Quora yesterday: What are the best resources for learning Oracle Database? The biggest learning curve to learning Oracle Database, SQL, PL/SQL, and all the other cool technologies that come with our database, is figuring out how to download, install, and create a database FIRST. And then of course you’ll have to configure a connection in either our command-line interface (SQL*Plus or SQLcl), our GUI/IDE (SQL Developer), or one of our…
This post is a tease. It’s also a request. Send me your ugly code. In version v4.2 of SQL Developer – to be released in calendar year 2016 – we’ll be offering a new formatter for your SQL and PL/SQL. It’s got a completely new engine under the hood. It’s faster. It’s more efficient. And it sounds really cool too – which is what most gearheads care about most. I’ve taken many, many, many requests…
Best practice for code readability dictates that your keywords should always be in: insert your preferred style here __________. Here’s a Twitter poll I’m running if you want to personally weigh in: Do you agree? Best coding practices dictate uppercase identifiers? https://t.co/WhOZvL2Bmv— Jeff Smith ☜ (@thatjeffsmith) March 16, 2016 So even if we can’t all agree on what’s best, we can all agree that our tools should help us get the code we inherit or…
I accidentally blogged this…twice. Here’s the other take. This happens more often than I care to admit, sorry. Forgive the inelegant post title – but it gets to the point, and I reckon it might be closer to what folks will be Googling. I get questions from time to time around getting SQL Developer to load or respond quicker. Here’s the advice/tips I generally lead with: Look and Feel You can tell SQL Developer to…
I just came from a DBA-dominated conference – Hotsos Symposium in Dallas, if you must know – and I came away with the impression that many a DBA out there is missing out on some key features and productivity-hacks in our dear ole IDE. I could give you 10 things, but I know DBAs are busy, so here are just 3: 1.)The Instance Viewer New since 2014 and version 4.1. Nothing to install in your…
If you have the Tuning Pack licensed, a couple of things become available for you in SQL Developer: SQL Tuning Advisor Real Time SQL Monitoring If you DO NOT have this pack licensed, then you can disable these features in the SQL Developer UI via the preferences: Semi-Rant: consider giving your developers access to this feature in their development and UAT environments. SQL Developer, EM, or just grant them exec privs on the packages and…
Does SQL developer support, col command that is used to format query results in sqlplus. like – col id heading app_id format a10 My answer was: ‘Yes.’ But I figured I should put up or shut-up a little bit, so here goes. You can read more about column formatting in SQL*Plus here (Docs). I used those same queries as a test in SQL Developer. Remember that when you use this button: … we emulate SQL*Plus…