Home » Infrastructure » Unix » about sqlplus line-edit command-history
about sqlplus line-edit command-history [message #97221] Wed, 23 January 2002 17:41 Go to next message
slimzhao
Messages: 5
Registered: November 2001
Junior Member
Anyone can solve the problem that sqlplus's line-editing and command-history under Unix-like OS?
bash & mysql is a good sample, both has a easy-to-use interface for generating a SQL to run.

Oracle's sqlplus can only use
c/original/target/
ed
CTRL-W
CTRL-U
COPY & PASTE

anyone has a rewrite version of sqlplus that has these features appears in bash or mysql?
Re: about sqlplus line-edit command-history [message #97225 is a reply to message #97221] Thu, 24 January 2002 12:06 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
see the sqlplus link at this location:
http://www.orafaq.net/faqscrpt.htm#UNIX
Re: about sqlplus line-edit command-history [message #97227 is a reply to message #97225] Fri, 25 January 2002 04:05 Go to previous messageGo to next message
slimzhao
Messages: 5
Registered: November 2001
Junior Member
Thanks, it's a good ideal to bypass hard-code to sqlplus instead of using a shell wrapper, I download it, but I find it doesn't work for me, I can't use the up-arrow & down-arrow to call history command back, nor CTRL-N & CTRL-P or CTRL-A CTRL-W CTRL-E, because my legancy experiment is bash-based, so I am not sure what's the problem is. Any suggestions about using a ksh & sx
PS:I use the ksh of pdksh rpm package. version 5.2.14-8
Re: about sqlplus line-edit command-history [message #97232 is a reply to message #97225] Mon, 28 January 2002 11:34 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://sourceforge.net/projects/yasql
Previous Topic: Re: Problem Creating a DataBase on LINUX
Next Topic: Calling shell script from pl/sql
Goto Forum:
  


Current Time: Thu Mar 28 08:00:58 CDT 2024