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 on start-up.