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:…
A co-worker asked me for some advice on building a report to view some CLOBs. CLOBs are fun. They let you store an unlimited (basically) amount of text. They’re not as flexible as VARCHAR2s, but they do come in handy. Viewing them in a report can get interesting though. The question came down to seeing a report like this – I suggested to my co-worker to use the SCRIPT type report instead. But then they…
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…
My friend Chet is facing some pretty large bills. They go to pay for therapy for his special needs daughter, Kate. Chet is @oraclenerd. He’s done a lot to help the community, and to help community members in need. We’ve started a fund-raiser to help Chet make sure his kids get the care they need. I try not to ask for much here, and keep this site mostly professional. But it’s my personal site, and…
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…
DELIMITED text files are popular ways of passing data around. CSV anyone? The C stands for ‘Comma’ – regardless of what your smug European friends may have told you 😉 #TonguePlantedFIRMLYInCheek Anyways, in SQL Developer, when using the export dialog to get a DELIMITED export for your dataset, you can set the delimiter and the string enclosure for your columns. So in the command line interface AKA SQLcl: So you could have BEER emoji separated…
Here’s how to format your sql and plsql code from the command line using Oracle SQLcl.
Since SQLcl is a command line tool, it’s not super helpful to have a huge command history list. How do I mean? Well, in the SQL Developer GUI, we have a History panel. It allows for sorting, filtering, scrolling, etc. So you can go ‘crazy’ and set your History limit to 1000 if you want. But, in SQLcl, we limit the user to their last 100 commands. Now there are many commands you’ll be running…
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…
I went to link to this post earlier today, and was shocked to discover I hadn’t actually written it yet. What’s the opposite of ‘bazinga!’ ? SQL Developer stores every query AND script you execute in a worksheet. A query being a single statement, and a script being one or more queries and/or anonymous blocks. A query is stored as a single item. A ‘script’ is stored as a single item. By DEFAULT, we store…