From oracle-l-bounce@freelists.org Tue Jan 11 13:25:03 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0BJP3Y22535 for ; Tue, 11 Jan 2005 13:25:03 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0BJP1n22524 for ; Tue, 11 Jan 2005 13:25:01 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 14CD772C51E; Tue, 11 Jan 2005 14:29:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01687-41; Tue, 11 Jan 2005 14:29:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F020372D243; Tue, 11 Jan 2005 14:26:55 -0500 (EST) From: "Ruth Gramolini" To: , Cc: Subject: RE: Yet another tool for Command_line_history for Linux DBA Date: Tue, 11 Jan 2005 14:22:53 -0500 Message-ID: <006401c4f812$f27f5f30$8459000a@vttaxnet.tax.state.vt.us> MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: X-archive-position: 14623 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rgramolini@tax.state.vt.us Precedence: normal Reply-To: rgramolini@tax.state.vt.us X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org And I will put in my $0.02. I love sqlworksheet (OEM) because you have a command line history. You can call up a command and run it on another database (after changing the connection). You can do inline editing so repeat commands which only need a word or two changed are easy to do. You are not the only devil around here, Jared ;-)) Ruth -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Jared Still Sent: Tuesday, January 11, 2005 2:12 PM To: dbanotes@gmail.com Cc: oracle-l@freelists.org Subject: Re: Yet another tool for Command_line_history for Linux DBA I'm gonna play Devil's advocate here: After many years of working on unix where there was no command line history available, I've found that it really is not that useful, at least for SQL*Plus. The OS command line is a different story, as most commands fit on a single line. Being able to search the command history and repeat a command, or edit a previously used one is extremely useful. Doing so on a SQL*Plus command line is less so. SQL statements are often more than one line, so it is necessary to up arrow to each line in succession, making sure it is the correct line, and then hit enter. Do this for each line in the statement. It is simply to easy in SQL*Plus to save the buffer to a file via the 'save' command, or simply 'get afiedt.buf' and 'ed'. I've tried SQL*Plus command line history tools, and find that they really aren't much benefit. Jared On Tue, 11 Jan 2005 18:34:10 +0800, Fenng wrote: > Hi,all , > > at Tom's AskTom(http://asktom.oracle.com) ,I saw : > [quote] > Do you use Linux? then you need rlwrap > http://www.dizwell.com/html/a_command_line_history.html . You won't > know how you survived without it. [/quote] > > yes ,the tool can "up-arrow in SQL*Plus and retrieve old commands",but > there is another common tool CAN do that too: > > uniread - http://sourceforge.net/projects/uniread/ > > [QUOTE]uniread - universal readline - adds full readline support > (command editing, history, etc.) to any existing interactive > command-line program. Common examples are Oracle's sqlplus or jython. > uniread will work on any POSIX platform with Perl. > [/QUOTE] > > BTW,I wrote a tips about uniread (in Chinese): > http://www.dbanotes.net/Oracle/uniread-howto.htm > -- > http://www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l