SQLcl

SQLcl connect target depends on previous connection

By Franck Pachot . I thought it was a bug for two reasons: first, because I don't like that my connect destination depends on the context, and then because it is a different behavior than in SQL*Plus. But finally, it(…)

sqlplus and its column output

During tuning or normal DBA activities one of the most annoying things is sqlplus with its default column output when running queries. I.e. even after setting a linesize of 1000 and a pagesize of 1000 the output may look as(…)

Connect-times to the DB suddenly become very slow using sqlcl

I recently wrote a couple of sql-scripts which had to run on all of my customer’s DBs. The sql-scripts had to be started from a Linux-client, which does not have any Oracle client software installed. So I thought of using(…)

SQLcl on Bash on Ubuntu on Windows

By Franck Pachot . I'm running my laptop on Windows, which may sound weird, but Linux is unfortunately not an option when you exchange Microsoft Word documents, manage your e-mails and calendar with Outlook and present with Powerpoint using dual(…)

Dbvisit replicate CDC without old values

By Franck Pachot . In a previous post I presented how Dbvisit replicate can capture changes and write them in an audit table with old and new values. Here is how to do it wen you want only the(…)