niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
· nixdoc.net · man pages · Linux HOWTOs · FreeBSD Tips · Forums
navigation Forum index » Databases » Oracle » Server
sqlplus command history: rlwrap and multiple line sql statements
Post new topic   Reply to topic Page 1 of 1 [6 Posts] View previous topic :: View next topic
Author Message
NetComrade
*nix forums Guru Wannabe


Joined: 24 Mar 2005
Posts: 241

PostPosted: Wed Sep 28, 2005 6:15 pm    Post subject: sqlplus command history: rlwrap and multiple line sql statements Reply with quote

OK..

Great for one-liners, but what about multiple lines?

Thanks.
........
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email
Back to top
Primoz
*nix forums beginner


Joined: 21 Mar 2005
Posts: 9

PostPosted: Sat Oct 01, 2005 6:47 am    Post subject: Re: sqlplus command history: rlwrap and multiple line sql statements Reply with quote

You can use / to repeat the previous sql statement. Oracle advise to
use iSQLplus and there you can edit your statements.

Best regards,
Primoz Mihelic

http://www.twisted-nail.com
Back to top
Egor Starostin
*nix forums beginner


Joined: 23 Sep 2005
Posts: 5

PostPosted: Sat Oct 01, 2005 2:01 pm    Post subject: Re: sqlplus command history: rlwrap and multiple line sql statements Reply with quote

Quote:
Great for one-liners, but what about multiple lines?
I use vim.

Here's some kind of howto: http://oracledba.ru/notes_vim_en.html


--
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
Back to top
Noons
*nix forums Guru


Joined: 05 May 2005
Posts: 534

PostPosted: Sat Oct 01, 2005 2:23 pm    Post subject: Re: sqlplus command history: rlwrap and multiple line sql statements Reply with quote

NetComrade apparently said,on my timestamp of 29/09/2005 6:15 AM:

Quote:
Great for one-liners, but what about multiple lines?

We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email


define _editor=vim

--
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k@yahoo.com.au.nospam
Back to top
NetComrade
*nix forums Guru Wannabe


Joined: 24 Mar 2005
Posts: 241

PostPosted: Mon Oct 03, 2005 6:53 pm    Post subject: Re: sqlplus command history: rlwrap and multiple line sql statements Reply with quote

On Sun, 02 Oct 2005 02:23:57 +1000, Noons <wizofoz2k@yahoo.com.au>
wrote:

Quote:
NetComrade apparently said,on my timestamp of 29/09/2005 6:15 AM:

Great for one-liners, but what about multiple lines?

We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email


define _editor=vim

I think people mis-understood my question.
rlwrap is used to add command history to sqlplus
http://www.dizwell.com/html/cli_history.html
however, it cannot recall the full sql command, if the command wrapped
for longer then one line
I do know how to use vi and 'edit' in sqlplus.

thanks.
........
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email
Back to top
Noons
*nix forums Guru


Joined: 05 May 2005
Posts: 534

PostPosted: Tue Oct 04, 2005 2:50 am    Post subject: Re: sqlplus command history: rlwrap and multiple line sql statements Reply with quote

NetComrade wrote:
Quote:


define _editor=vim

I think people mis-understood my question.
rlwrap is used to add command history to sqlplus
http://www.dizwell.com/html/cli_history.html
however, it cannot recall the full sql command, if the command wrapped
for longer then one line
I do know how to use vi and 'edit' in sqlplus.


Didn't say you didn't, buddy. Just suggested you use
it. Because I don't think there is an exact parallel
with WIndows available in the Looneecks world. Wink
Still, if there is I'd love to hear details.
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [6 Posts] View previous topic :: View next topic
The time now is Sun Apr 20, 2014 2:17 pm | All times are GMT
navigation Forum index » Databases » Oracle » Server
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Configure Postfix to relay mail to multiple internal servers tristopherr Postfix 0 Fri Aug 06, 2010 7:03 pm
No new posts how to read the mail structure from command line ? naspar Postfix 0 Thu Jun 17, 2010 8:38 am
No new posts Postfix Multiple Relay Hosts? blaze Postfix 0 Wed Jun 25, 2008 5:02 am
No new posts Deliver msg to multiple hosts jures Postfix 2 Fri Feb 29, 2008 4:21 pm
No new posts List History Backup Gladiator IBM DB2 3 Fri Jul 21, 2006 8:21 am

Copyright © 2004-2005 DeniX Solutions SRL
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum |  email marketing service
 
Privacy Policy
[ Time: 0.0760s ][ Queries: 16 (0.0448s) ][ GZIP on - Debug on ]