You’re at the command-line, you need to add a data file to your tablespace. You get most of the way through it, and you forget what’s next, doh! In SQLcl, you can just hit the TAB key, and we’ll help you with the next keyword. So not only do we have tab-completion for object and column names, we also look up keywords from the syntax diagrams in the Oracle Docs. Confused? Here’s an animated GIF.…
Idiom:in a nutshellIn a few words; concisely: Just give me the facts in a nutshell. Ok, so I used more than a few words, but if I told you that SQL Developer was a GUI version of SQL*Plus – I’d be leaving out a WHOLE LOT of important stuff. If that’s all you’re using it for, you might be missing out. So here are some quick-links to learn more about each of these feature areas:…
We love getting enhancement requests from our users. A good deal of the development in SQL Developer is guided by what our users are asking for. It does pain me a bit though when someone asks for a feature what we already have. Example: We frequently have a requirement to export working data (especially for data modeling purposes) to spreadsheets. It would be helpful if SQL Developer export had an option to export all tables…
Virtual columns made their debut in Oracle Database 11g. They are a value that’s not stored with the row, rather they are computed as queried. [DOCS] So I could have a column of type DATE. And I could have a virtual column of type VARCHAR2 that is computed by running a function against the previously mentioned DATE column. How would I model this? In your relational, or even logical design, you can set a column’s…
Question: I like SELECT *, but I don’t really want ALL the columns. Is there a better way? Side Note: People are giving me crap on the ‘SPLAT’ – it’s perfectly acceptable! To me at least… There’s a few better ways, and with an IDE like SQL Developer, you should expect lots of help in this area. drag and drop cols from the tree * expansion the Query Builder code insight I have how-to’s on…
Our Database Insider Newsletter folks asked me to share some resolutions I had for 2016. 2015 was a great year for me, personally and professionally. I’m also continuously reminded of the things I don’t do so well and need to get better at. So here goes… Find new ways to reach and help our users. Not everyone gets to attend a conference. Not everyone has time to read blogs. Our team wants our customers to…
These were the stories published this year that enjoyed the most readers. Sadly, an article I wrote many years ago on how to import data from Excel to Oracle, remains the #1 post overall. Stupid Excel. 10. SQL Developer version 4.1 Feature Recap So we released version 4.1 of SQL Developer this past May. This post summarizes the new features with detailed stories on each. One of my favorites is the Diagram page we added…
Here’s how to format your sql and plsql code from the command line using Oracle SQLcl.
Doing the math, SQL Developer is officially 10 years old. Or should I say, 10 years young? I remember VERY clearly when this came out. It was seen as a very disruptive move by Oracle – a company for which I did not work at the time, so this is my personal recollection 🙂 It was also not the first developer tool to come from Oracle. But this one had a lot of people excited.…
Updated 25 May 2022 This is formerly a trick. We made this just a simple action of opening the User and going to the SQL panel in the DBA, Security section. If this isn’t working for you, it’s because you’re on an older version of SQL Developer…in which case, read on. The Trick, if you’re on an older copy of SQLDev This challenge has come up a few times recently for me. Just HOW can…