It’s ‘set history limit 200’
Did you know that SQLcl actually keeps your history between sessions? I’m glad
for our SQL*Plus users that it finally has a history now, and also supports the
CSV output.
Having a sep login.sql for SQLcl would be nice though.
From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
Sent: Saturday, June 15, 2019 1:30 PM
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: sqlcl and sqlplus (Jeff Smith)
Also "set history 200" breaks SQLcl:
SQL> set history 200
Invalid set history optionSET HISTORY
---------
set history [FAILS [LIMIT [ n | DEFAULT ] ] | NOFAILS
|BLACKLIST [DEFAULT <command list>?|<command list>?]
|LIMIT [n|DEFAULT]]
FAILS sets history command to show failed statements.
use limit to limit number of failues
NOFAILS sets history command to not show failed statements
BLACKLIST sets a list of sqlcl commands that can be excluded from the
history
LIMIT sets a new max size for the history
Sqlplus has absolutely no problems with "set history 200". Of course, my
developers absolutely love history run <n> and history <n> edit commands. The
two programs are different enough to warrant two different login.sql
initialization files.
Regards
On 6/15/19 1:02 PM, Mladen Gogala wrote:
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.
Regards
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217