This post is the first one of three that together are an introduction to scripting in SQLcl.Also read part 2 and part 3. For many years now SQLcl is my favorite command line tool to connect to Oracle databases. (available at the bottom of the SQL Developer download page)It does (practically) everything SQL*Plus does and a whole lot more. It has many capabilities that SQL*Plus just doesn’t have.But this post is not about those goodies SQLcl delivers, it’s more or less about what is doesn’t…. No matter how good we think a tool is, and I think SQLcl is great, there will always be things missing, or not quite the way we would want them to be.SQLcl is no exception to this rule.Inevitably we run into something that makes us think “I wish it could do ….”.The team that brings us SQLcl (and SQL Developer and Datamodeler and ORDS) is … Continue reading →