sqlcl and sqlplus (Jeff Smith)

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 15 Jun 2019 13:02:20 -0400

I am using a brand new Oracle 19c test VM and unfortunately, I am not the only one. Since both SQLcl and sqlplus come with the installation, I opted for sql and have put "set sqlformat ansiconsole" among other things in $ORACLE_HOME/sqlplus/admin/glogin.sql because both sql and sqlplus are reading that file. However, my colleagues are getting an error when they attempt usng sqlplus, so I have removed the offending directive from glogin.sql. Since those tools are diverging more and more, would it be possible to separate the initialization SQL files for both tools?

This question is primarily for Jeff Smith, the product manager.


Mladen Gogala
Database Consultant
Tel: (347) 321-1217


Other related posts: