I’m always looking for things. I love the ALT+G trick in SQL Developer. But what about the command-line? One of the really nice things about SQLcl is that if you can’t do what you want with the available commands, you can just build your own. That’s especially true now that we have JavaScript support. But this is just plain, straight up SQL. To build your own command, use ‘ALIAS’. 795268298680c77aa895aa_000000 You can probably guess what…
Remember back when Corel first released WordPerfect? Remember how it had like a bazillion keyboard shortcuts, and you needed help remembering them all? No? You probably also don’t remember a world sans e-mail and smart phones either. Oh well. Anyways, we have lots of keyboard shortcuts in SQL Developer and a few in SQLcl. You might need help remembering them. Cue the ‘nerd stick.’ Or at least that’s what I’ve always called these. Maybe I’ll…
You want to drop, purge 10 tables, and you don’t want to select, click, click, click 10x. What’s a SQL Developer user to do? Well, if you want to live dangerously, you could build a custom extension for SQL Developer to do that for you. We tweaked the IDE to allow this in version 4.1.2 – if you’re on any version PRIOR to version 4.1.2, this won’t work. BASICALLY… You can have an item type…
This has been around for a loooooong time. But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling. Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to PAUSE. SET PAUSE ON [DOCS] in sql*plus allows a script to ‘pause’ until you hit ‘ENTER’ for it to continue.…
Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of this for all of my debugger posts. Hint, scroll down to just right above where the comments start. Click on…
For those Windows users out there who want both a BASH shell AND a really cool command line interface to Oracle Database – I have good news! We updated SQLcl yesterday to include support for CYGWIN. I have Cygwin64 and Windows 7. We also added a new command, SHOW TNS. This will help you figure out how and where we’re finding your TNSNAMES* files. 795268298680c77aa895aa_000006 So we’ll look in your home directory, your TNS_ADMIN space,…
When demonstrating SQLcl, I get the feeling that half of the audience is filled with dread. Yes, they love everything that I’m showing them. But deep, deep down they are scared that the things they personally liked in SQL*Plus are going away. I’m here today to alleviate those concerns. Instead of asking you to just take my word for it, I’ll show you. Now of course you COULD just download it yourself and have a…
I’m a fan of both. When describing an Entity, I like to keep it ‘real.’ My beer or brewery doesn’t have an ‘ID.’ But when I go to manage this data in the real world, I don’t want 3 or 4 columns used to uniquely identify a record in my table. Or tuple if you want to be all fancy. So can I have it both ways? Yes. In your logical design, define your entities…
One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010. 2010. Wow, I says to myself – that’s gotta be interesting to a lot of folks, what is it? It’s a question on how to find table or view columns. And the ‘correct’ answer is to use SQL. Which is of course the right answer, and was the right answer in 2010…
It’s that time of year again: planning for our biggest customer and user event, Oracle Open World. I recently shared some advice for getting the most out of your conference experience, here’s a 2 minute video: One of the bits there I suggested was to mark one or two sessions a day that you might want to attend. Well, since you’re here, I’m assuming you might find the stuff our team is doing appealing. Note…