ThatJeffSmith

Tag: script

Extending Oracle SQL Developer Command Line (SQLcl) with JavaScript: Single Record Viewer

Oracle SQL Developer Command Line (SQLcl) is the full name for what we’ve been calling, SQLcl. Have you seen the video? It’s only 8 minutes and will catch you up on just what SQLcl is. Anyways, there’s a ‘new’ command called SCRIPT that I want to show you today. I say ‘new’ because we added […]

Similar Posts by Subject Areas: , ,

Having Fun With Prompts – and Saving Yourself from Mistakes

In SQL Developer we have color coded connections. This was added, not because we like Christmas trees and all the pretty lights, but because sometimes you need a reminder of what database you’re on. So you don’t TRUNCATE stuff, accidentally. Visual cues won’t prevent all mistakes, but they sure help. With SQLcl, you have the […]

Similar Posts by Subject Areas: , , , , ,

Formatting Columns in SQL Developer a la SQL*Plus

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

Similar Posts by Subject Areas: , ,

SET PAUSE ON

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

Similar Posts by Subject Areas: , , , ,

A Quick 4.1 Trick: SET SQLFORMAT

One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer Meets SQL*Plus?

If you weren’t paying attention over the Christmas/Winter break, it’s very possible that you haven’t heard about our new project. You can find it on the SQL Developer version 4.1 Early Adopter download page.. If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Posts in 30 Days, Day 22: It’s All in the Font

As much as I like the traditional explain plan support in SQL Developer, and even the ability to pull cached plans out by the SQL_ID – sometimes you just want to get the plan the old fashioned way. The New Way The Older Way Ugh. That’s a little icky to read. Remember – you need […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,