RE: SQL Command list history on Linux

Some things to remember about SQLcl:

+ it’s supported via MOS

+ it ships with Oracle db installs now

+ also ships with SQLDev

+ requires at least a Java 8 JRE

Some things to remember about its history command

+ on by default

+ history items persist between sessions

+ limit is 100 statements, but can be adjusted higher

+ supports blacklisting of commands to be stored in history, like a CONNECT

+ also includes anon blocks, not just statements

17.4 just came out 2 weeks ago. Let me know if you have any questions.

Jeff

From: Sweetser, Joe [mailto:JSweetser_at_icat.com] Sent: Tuesday, January 02, 2018 3:54 PM
To: andysayer_at_gmail.com; JBECKSTROM_at_gcrta.org Cc: oracle-l-freelist <oracle-l_at_freelists.org> Subject: RE: SQL Command list history on Linux

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: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Sayer Sent: Tuesday, January 2, 2018 1:46 PM
To: HYPERLINK "mailto:JBECKSTROM_at_gcrta.org"JBECKSTROM_at_gcrta.org Cc: oracle-l-freelist <HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org> 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:

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Fdocs.oracle.com-252Fen-252Fdatabase-252Foracle-252Foracle-2Ddatabase-252F12.2-252Fsqpug-252FHISTORY.html-2523GUID-2DCCF9B047-2D3122-2D4644-2DBA06-2D5FA4B5812E9F-26data-3D02-257C01-257CJSweetser-2540icat.com-257Cf2551526be5c47bc7fd708d55221fd44-257C5d3bf30e9adb4c17b2425c17523e6e5e-257C0-257C0-257C636505228296022665-26sdata-3DaoSDQl9exbFKBdgi6IBdolsiKnK3EjEMCFj284vW37U-253D-26reserved-3D0&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=5GUzZEpCxEVtqTQQSaxHoMMT8gQP8oAoyYLXgFZlAo0&s=HPZovAUbaWqcW7X4T5E0WKx7-ZyouvN7hwgjGY8VCoM&e="https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/HISTORY.html#GUID-CCF9B047-3122-4644-BA06-5FA4B5812E9F

Regards,

Andrew

On Tue, 2 Jan 2018 at 20:42, Jeffrey Beckstrom <HYPERLINK "mailto:JBECKSTROM_at_gcrta.org"JBECKSTROM_at_gcrta.org> 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

HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Fmaps.google.com-252F-253Fq-253D1240-252BW.-252B6th-252BStreet-252BCleveland-252C-252BOhio-252B44113-2526entry-253Dgmail-2526source-253Dg-26data-3D02-257C01-257CJSweetser-2540icat.com-257Cf2551526be5c47bc7fd708d55221fd44-257C5d3bf30e9adb4c17b2425c17523e6e5e-257C0-257C0-257C636505228296022665-26sdata-3DpxHkA8wLGt1tdcwkOcy-252B41wxmsCWyGjTS7wNXGZ5-252BFk-253D-26reserved-3D0&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=5GUzZEpCxEVtqTQQSaxHoMMT8gQP8oAoyYLXgFZlAo0&s=F5vrHEkJd9EuVMlAiIw0U2KXwgIlCMIM7Bk0DHgj4Po&e="1240 W. 6th Street HYPERLINK "https://urldefense.proofpoint.com/v2/url?u=https-3A__na01.safelinks.protection.outlook.com_-3Furl-3Dhttps-253A-252F-252Fmaps.google.com-252F-253Fq-253D1240-252BW.-252B6th-252BStreet-252BCleveland-252C-252BOhio-252B44113-2526entry-253Dgmail-2526source-253Dg-26data-3D02-257C01-257CJSweetser-2540icat.com-257Cf2551526be5c47bc7fd708d55221fd44-257C5d3bf30e9adb4c17b2425c17523e6e5e-257C0-257C0-257C636505228296022665-26sdata-3DpxHkA8wLGt1tdcwkOcy-252B41wxmsCWyGjTS7wNXGZ5-252BFk-253D-26reserved-3D0&d=DwMGaQ&c=RoP1YumCXCgaWHvlZYR8PZh8Bv7qIrMUB65eapI_JnE&r=N2hWu5HFsaIjmMkjQbnlokJ7uinNZMgPVk8rqPT9esM&m=5GUzZEpCxEVtqTQQSaxHoMMT8gQP8oAoyYLXgFZlAo0&s=F5vrHEkJd9EuVMlAiIw0U2KXwgIlCMIM7Bk0DHgj4Po&e="Cleveland, Ohio 44113

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.

--
http://www.freelists.org/webpage/oracle-l