Oracle SQLcl, Why?

thatjeffsmith SQL Developer 19 Comments

Oracle SQL*Plus has been around since 1985. It does what it does, and it does it well. SQL Developer has been around since 2006. It’s become the de facto IDE and GUI for the Database. There was an opportunity to build something new that could take the command line interface and enhance it to meet the needs of today’s database …

SET PAUSE ON

thatjeffsmith SQL Developer 3 Comments

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] …

CYGWIN and SQLcl

thatjeffsmith SQL Developer 20 Comments

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 …

Updated SQLcl: nicer inline editing and column completion

thatjeffsmith SQL Developer 22 Comments

We updated the Early Adopter offering of SQLcl today. Go get it. But first, I’m assuming you’ve heard of SQLcl? If not – Read the slidedeck, watch the movie. We’ve put in a ton of enhancements and even more bug fixes. And Kris showed off a new feature today that mimic’s our SQL Developer grid preference for displaying NULL ‘values’… …

Tailing the Alert Log with SQLcl

thatjeffsmith SQL Developer 3 Comments

Hopefully you’ve heard about the new SQL*Plus we’re building. And hopefully you’ve heard about the new REPEAT command we put into it yesterday. Here’s a quick example of how to build a little ‘monitor’ in just 2 commands, a total of 5 lines of code. The SQL SELECT To_Char(Originating_Timestamp, ‘DD-MON-YYYY HH24:MI:SSxFF’) Time_Entry, substr(message_text, 0, 75) || ‘…’ ABBR_MESSAGE_TEXT FROM X$dbgalertext …