SQLcl History Demo and How to Extend History Limit

thatjeffsmith SQL Developer 0 Comments

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 …

Having Fun With Prompts – and Saving Yourself from Mistakes

thatjeffsmith SQL Developer 1 Comment

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 …

Related Posts Plugin for WordPress, Blogger...