This is new to me (12.2 sqlplus history) and, while it’s a definite improvement
over not having any history in sqlplus, it seems a bit clunky command-wise to
me.
In addition to what others have mentioned, it might be a good time to consider
this:
http://www.oracle.com/technetwork/developer-tools/sqlcl/overview/index.html
hth,
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Andy Sayer
Sent: Tuesday, January 2, 2018 1:46 PM
To: JBECKSTROM@xxxxxxxxx
Cc: oracle-l-freelist <oracle-l@xxxxxxxxxxxxx>
Subject: Re: SQL Command list history on Linux
Hi Jeffrey,
If you download the 12.2 client you can take advantage of the new history
functionality:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/HISTORY.html#GUID-CCF9B047-3122-4644-BA06-5FA4B5812E9F<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fen%2Fdatabase%2Foracle%2Foracle-database%2F12.2%2Fsqpug%2FHISTORY.html%23GUID-CCF9B047-3122-4644-BA06-5FA4B5812E9F&data=02%7C01%7CJSweetser%40icat.com%7Cf2551526be5c47bc7fd708d55221fd44%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C636505228296022665&sdata=aoSDQl9exbFKBdgi6IBdolsiKnK3EjEMCFj284vW37U%3D&reserved=0>
Regards,
Andrew
On Tue, 2 Jan 2018 at 20:42, Jeffrey Beckstrom
<JBECKSTROM@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>> wrote:
I am coming from a Windows environment in which SQL plus does have a command
line history. In Linux, running SQL Plus, an up arrow key returns garbled
characters. Is there a way to activate the command line history for Linux
servers running SQL Plus?
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th
Street<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D1240%2BW.%2B6th%2BStreet%2BCleveland%2C%2BOhio%2B44113%26entry%3Dgmail%26source%3Dg&data=02%7C01%7CJSweetser%40icat.com%7Cf2551526be5c47bc7fd708d55221fd44%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C636505228296022665&sdata=pxHkA8wLGt1tdcwkOcy%2B41wxmsCWyGjTS7wNXGZ5%2BFk%3D&reserved=0>
Cleveland, Ohio
44113<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D1240%2BW.%2B6th%2BStreet%2BCleveland%2C%2BOhio%2B44113%26entry%3Dgmail%26source%3Dg&data=02%7C01%7CJSweetser%40icat.com%7Cf2551526be5c47bc7fd708d55221fd44%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C636505228296022665&sdata=pxHkA8wLGt1tdcwkOcy%2B41wxmsCWyGjTS7wNXGZ5%2BFk%3D&reserved=0>
This e-mail transmission and any attachments that accompany it may contain
information that is privileged, confidential or otherwise exempt from
disclosure under applicable law and is intended solely for the use of the
individual's to whom it was intended to be addressed. If you have received this
e-mail by mistake, or you are not the intended recipient, any disclosure,
dissemination, distribution, copying or other use or retention of this
communication or its substance is prohibited. If you have received this
communication in error, please immediately reply to the author via e-mail that
you received this message by mistake and also permanently delete the original
and all copies of this e-mail and any attachments from your computer. Please
note that coverage cannot be bound or altered by sending an email. You must
receive written confirmation from a representative of our firm to put coverage
in force or make changes to an existing policy.
