ThatJeffSmith

Tag: sqlcl

Oracle as a Document Store {JSON} and Oracle SQLcl

JSON – it’s the new whiz bang. JavaScript has taken off, and you don’t need to take my word for it. And with JavaScript comes JSON. There are so many libraries on GitHub that are about turning data into really slick web and mobile applications. We have our own set of libraries available – have […]

Similar Posts by Subject Areas: , ,

Custom SQLFORMATs with SQLcl

When I make jokes about copying and pasting code from StackOverflow or Github, I’m not really joking. But in this case, it’s OK. Because, I’m copying and pasting code from OUR GitHub project, AND my boss wrote the code. A question came in, and it’s come in a few times, but here’s the most recent […]

Similar Posts by Subject Areas: , , ,

Latest Tips & Tricks

I made some small, but important changes to my SQL Developer Tips & Tricks slide deck. changed up the order – the first two tricks ARE THE MOST IMPORTANT now optimized for SlideShare – hopefully easier to consume in case I’m not there to narrate/live demo added a few teasers for SQLcl I really, really […]

Similar Posts by Subject Areas: , , ,

Blacklisting Commands in Your Oracle SQLcl History

We by default don’t store certain things in your SQLcl HISTORY list – like CONNECTs. For obvious reasons, it’s best not to store certain things, either for convenience or for security. Here’s how that is controlled. SET HISTORY BLACKLIST command1, command2, …, commandN An example: So I previously added ALTER to the list, and just […]

Similar Posts by Subject Areas: ,

SQLcl History Demo and How to Extend History Limit

Twitter wasn’t playing nice, so I’ll just blog this 🙂 Want to extend your history size from 100 statements/scripts? Add this to your login.sql. prompt Bumping up SQL History to 250 Items script var MultiLineHistory = Java.type("oracle.dbtools.raptor.console.MultiLineHistory"); MultiLineHistory.getInstance().setMaxItems(250); / Don’t go crazy, remember each item gets written to its own XML file. We load those […]

Similar Posts by Subject Areas: ,

SQL Developer Release Party: Download all the Things

Oracle SQL Developer Command Line (SQLcl) is now officially available. (Download) Thanks to the many of you who provided feedback and helped us make this ready. We plan on very regular updates, every 60-90 days, so the fun hasn’t stopped. Oracle SQL Developer v4.1.5 is now officially available. You can now drag and drop objects […]

Similar Posts by Subject Areas: , ,

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: , , , , ,

Unicode and Oracle SQLcl…on Windows

I have an UMLAUT table. Pretty simple really… CREATE TABLE "HR"."UMLAUT" ( "CHARACTERS" VARCHAR2(2) ) ; REM INSERTING INTO UMLAUT SET DEFINE OFF; INSERT INTO UMLAUT (CHARACTERS) VALUES (’Ñ’); INSERT INTO UMLAUT (CHARACTERS) VALUES (’Ä’); INSERT INTO UMLAUT (CHARACTERS) VALUES (’Ñ’); COMMIT; Looks great in SQLDev, but not so much in SQLcl… Everything is UNICODE […]

Similar Posts by Subject Areas: , ,

SQLcl: ANSICONSOLE and Column Header Formatting

Question: Why is SQLcl truncating my column header names? It doesn’t do it if I use SET SQLFORMAT ANSICONSOLE though… Answer: Because, SQL*Plus. Longer Answer: SQLcl follows the SQL*Plus rules. And in this case, the rule is: The default width of CHAR and VARCHAR2 (VARCHAR) columns is the width of the column in the database. […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,